Change row color based on the value of a cell in a particular colum

[[email protected]]

Hi All,

As detailed above. using the attached spread sheet, I need to change the colour of any row where the value of any cell in column D is 1 to blue, the colour of any row where the value of any cell in column E is 1 to Yellow, the colour of any row where the value of any cell in column F is 1 to Red and the colour of any row where the value of any cell in column G is 1 to Green.

I hope that makes sense?

I know I need to use conditional formatting but for the life of me cannot figure it out.

Can you help me?

Thanks in advance

Jamie

Master Tracker.xlsx

[Craig K.]

Your conditionals are fine, you just need to edit the rule so that the equation is =$D1=1 and not =$D1="Y" like it is now.