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.