Conditional formatting

L

lilwoozy

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?
 
K

Kevin B

In D7 format the cell as you have indicated in your post, but change the
function to the following:

=NOT(Y7)
 
D

David Biddulph

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.]
 
L

lilwoozy

Kevin and David,

I entered =Y7=FALSE
When I went back to CF it read ="Y7=FALSE"

Y7 contains the boolean FALSE
 
Top