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