| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
| Conditional formatting | Excel Discussion (Misc queries) | |||
Linear Mode
