Conditional Format with Formulas

Occasional 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.