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