Conditional formatting
 

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?

Conditional formatting
 

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

=NOT(Y7)
--
Kevin Backmann


"lilwoozy" wrote:

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?

Conditional formatting
 

Bingo! That did the trick.

Why did it not work the way I wrote it?


"Kevin B" wrote:

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

=NOT(Y7)
--
Kevin Backmann

Conditional formatting
 

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?

Conditional formatting
 

Did you omit the = sign when you did it initially?
--
Kevin Backmann


"lilwoozy" wrote:

Bingo! That did the trick.

Why did it not work the way I wrote it?


"Kevin B" wrote:

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

=NOT(Y7)
--
Kevin Backmann