Does Y7 contain the boolean False, or the text string "FALSE"?
What happens if you put the formula =Y7=FALSE into a cell?
Have you been back into CF for D7 to check that the formula still says what
you intended it to say? [There is something of a tendency for Excel to
change what you asked for.]
--
David Biddulph

"lilwoozy" wrote in message
...
If cell Y7 = FALSE then I want D7 to turn font color red.

Under CF I selected "Formula Is" and entered =Y7=FALSE
and then selected the font color. It doesn't seem to be working, so I'm
guessing that I entered the formula wrong?