View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default 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?