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