Oct 25 2022 07:23 AM
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.
Oct 25 2022 07:39 AM
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.