Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

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