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.