You have to add the address of the cell that contains the formula.

If your original formula is in A1, and A1 is what you're looking to turn
red, then select A1 when creating your CF, and your *conditional* formula
should be:

=A1="Past Due"
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Oddcarout" wrote in message
...
=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