Hello all,
Please can someone guide me with my problem
I want to higlight cells in column D, cell D2 onwards when the adjacent cell i.e A2 has a value other than closed or complete. If A2 has closed or complete, D2 can be in green. If A2 has a value such as Assigned, D2 should be red. I tried a formula berlow with no success in conditional formatting:
=$A2="<>Closed", "<>Complete"
Please can someone help. thank you
Bookmarks