Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Excel 2003
I want cell G4 conditionally formatted if a zero (0) is entered, but no action if left blank. To simply program "G4=0" formats the cell when empty because zero and null evaluated as the same? But when I use this formula it works... =AND(G4<"",G4=0) So, is this the recommended hoop to jump through to make it work or is there a better way? Thanks, Melina |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Very Simple formatting Question | Excel Discussion (Misc queries) | |||
Simple formatting question.... | Excel Discussion (Misc queries) | |||
simple conditional formatting | Excel Discussion (Misc queries) | |||
Conditional formatting, simple question... | Excel Worksheet Functions | |||
Conditional formatting--simple question | Excel Worksheet Functions |