How to compare a column with a cell id instead of value using google sheets conditional formatting option?

0
votes

I want to change the background color of a particular cell in a column if the value of that cell is greater than one cell in another column.

For example, the column that I want to compare all cells is Y and the cell that should be compared with is AA5

Right now I am manually comparing by adding the value of AA5 to the greater than format rule in google sheets conditional formatting.

I tried using =IF($Y:$Y>$AA5) and =$Y:$Y<$AA5 in the custom formula but didn't work.

Need help on this.

this is how I tried, please refer the screenshot

1
google-sheetsgs-conditional-formattinggoogle-sheets-formula
=IF(Y1>AA$5, 1) and =Y1>AA$5 should work too – player0
that worked, can you tell me how to add the background color to a row if the value in y column and z column is greather than AA5 for Y value and AA7 for Z value, I tried =AND($Y:$Y>AA5,$Z:$Z>AA8) this but didn't work? – chiju

1 Answers

0
votes
  • apply to range Y1:Y
  • select Greater than
  • custom formula: =AA$5

enter image description here