color cell when another cell is equal to specific work

[graiggoriz]

Hello,

When I have the cell B1 = to "OK" --> I would like to have the cell A1 in Green

AND

When I have the cell B1 = to "NOK" --> I would like to have the cell A1 in Red.

I tried conditional formating but I manage to do it in the same cell which isn't my goal.

many thanks in advance,
Graig

[jeffreybrown]

Hi Graig,

Not sure how you can have an AND for B1. B1 can only either be "OK" or "NOK" or something else.

In A1 >> CF
=$B1="NOK" >> Red
=$B1="OK" >> Green

What have you tried and where are you getting stuck?

[sbehera]

Hi, give a watch to the below video....

http://www.youtube.com/watch?v=K_IEC2dCgIk