0

How do I use conditional formatting highlight cells in a range where the value in the cell matches the value in a specific column in the same row in Google Sheets.

For example:

enter image description here

2 Answers 2

1

cond2

This is the correct custom formula to apply to the range B2:F:

=and($a2=b2,$a2<>"")

cond

0

To use conditional formatting to highlight cells in a range where the value in the cell matches the value in a specific column in the same row in Google Sheets, you can use a custom formula and the $ symbol to create a relative reference to the column you want to compare the cell's value to.

Here are the steps to do this:

  • Select the range of cells that you want to apply the conditional formatting to.

  • In the toolbar at the top of the page, click on the "Format" dropdown menu and select "Conditional formatting".

  • In the "Conditional formatting" panel that appears on the right side of the page, click on the "Add a rule" button.

  • In the "Format cells if" dropdown menu, select "Custom formula is".

  • In the "Value or formula" field, enter the following formula, replacing "A" with the column letter you want to compare the cell's value to: =A2=A

  • Use the "Formatting style" options to specify the formatting that should be applied to cells that match the condition in the formula.

  • Click on the "Done" button to save the rule and apply the conditional formatting to your selected range.

Here is an example of how this formula might look in the "Conditional formatting" panel:

Format cells if:
Custom formula is: =A2=A
Formatting style: Bold
1
  • "you can use a custom formula and the $ symbol" Where did you think you were using the $ ?
    – Daniele
    Commented Dec 3, 2022 at 20:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.