Forum Discussion
Conditional Format with Formulas
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.
Your error check is returning 0% as text.
Change it to this where needed:
=IFERROR((D4/F4),0%)0% must not be enclosed in quotes.
