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

Conditional Format with Formulas

Brass Contributor

I have a conditional format set on anything that is less than 6%. However, if there are zero's in the data and the formula defaults to zero (IFERROR formula) then it returns 0% but does not change colors. How do I fix it? 


Attached is an example.

1 Reply


Your error check is returning 0% as text.


Change it to this where needed:


0% must not be enclosed in quotes.