Conditional Formatting Question

[JDechant]

Hi,

I have a row of cells that I would like to all be shaded based on the value of 1 cell.

So, for example, If cell E15 = 'Complete' the highlight cells A15:N15 with the colour green.

I've figured out hot to shade 1 cell based on it's value, but I want to shade multiple cells based on the value of 1 cell.

Is this possible?
If so, can someone walk em through how to do this?

Thanks
JDechant

 

[VoG]

Select A15:N15 and use the CF formula

=$E15="Complete"

 

[JDechant]

Simple as that aye... Sweet! Thanks!