Conditional Formatting is not applying to an IFError formula result.

Hello,

I have the formula =IFERROR(COUNTIFS(Table1[Week Due Hidden],(WEEKNUM(NOW())),Table1[Closed On-time],"Yes")/(COUNTIFS(Table1[Week Due Hidden],(WEEKNUM(NOW())),Table1[Closed On-time],"Yes")+(COUNTIFS(Table1[Week Due Hidden],(WEEKNUM(NOW())),Table1[Closed On-time],"No"))),"0") When it returns the "0" value I wanted it to be formatted with a Red fill.

I used the conditional formatting formula, Cell Value < 1
How is 0 not less than one? Is there something about the IfError function that negates conditional formatting?

Thanks for any and all assistance.

Try with the zero at the end of the formula NOT in quotes.

When it is, it's effectively a text value and Excel decides that's greater than 1.

BSB.

NeverMind..

Originally Posted by Norie

Isn't the formula the OP posted on the worksheet?

Yes, that's the way I read it. And why I removed my previous comment..

The formula is in a Cell.
Then the conditional formatting is using Cell Value is Less Than 1

Oh Right...I always forget that excel takes quotes as text.

Norie and BadleySpelledBuoy Thank you both!