Conditional Formatting

Copper Contributor

Good Morning,

 

Does anybody know a formula for the following;

 

I'm trying to say...If B8="Complete", A8 turns green. And if B8="Outstanding, A8 turns red. 

 

Any help would be greatly appreciated!

1 Reply

@Callumc123 See picture below.

Riny_van_Eekelen_0-1705496984362.png