Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In Excel 2003, I'd like to apply colored shading to a cell if it's blank.
I select: Cell Value Is equal to "" When I check it, the value box contains: ="""""" (6 quotation marks) I can edit the value so it reads: ="" (2 quotation marks) and that works. But there's got to be an easier way to enter a conditional format to check for a blank cell. Any suggestions? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting if cell is Blank | Excel Worksheet Functions | |||
formula setting cell type to blank and conditional formatting | Excel Worksheet Functions | |||
Conditional formatting to test blank text cell | Excel Worksheet Functions | |||
put zero in blank cell using conditional formatting | Excel Worksheet Functions | |||
conditional formatting blank cell | Excel Discussion (Misc queries) |