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

@CatherineMadden 

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.