Conditional formatting

[Oakey]

How can i add a conditional format that will allow me to change a number of cells when a specific criteria is met,

IE,

If cells A2 to k2 contain data, i want the cells to change green when the word Open appears in I2, I would then want them to turn Red once i change the work to Closed.

I would also like this format to be added to 000's of rows

Any help would be much appreciated

Thanks in advance

 

[Special-K99]

Select the range A2:K2

Conditional Formatting
New Rule
Use a formula to determine...
2 formulas needed, one for each colour

=AND(A2<>"",$I$2="Open")
format as green

=AND(A2<>"",$I$2="Closed")
format as red

 

[Oakey]

Thank you for this.

How do i copy the conditional format to do the rest of the sheet, but remains white until the data has been put in?

 

[Special-K99]

Just select the range you want the format to apply to.

It should (untested) only format the cells when I2 is Open or Closed AND there is data in the range selected.