use formula is =F6<$B$1

It's the same condition that causes the IF() formula to return Past Due

"Oddcarout" wrote:

=IF(D6="Yes", "Complete", IF(F6=$B$1, "Current", "Past Due"))

I want it to be red if "Past Due"

for the conditional I have Formula is ="Past Due"

but that does not work.

thanks