| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Cells With Values 0 and Null
I want the background of a cell one color if it holds a value of 0, another
color if it is null or empty, and another color if the value is 0<11. It seems that Excel treats 0 and an empty cell the same. Whatja think? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting Cells With Values 0 and Null
These rules worked for me
for the blanks: =ISBLANK(A1) for the zeros: =AND(ISNUMBER(A1),A1=0) for the 0<11= =AND(A10,A1<11) The 'trick' was ISNUMBER in the zero check! Otherwise it captures the blanks also. best wishes "Rookie Access User" wrote in message ... I want the background of a cell one color if it holds a value of 0, another color if it is null or empty, and another color if the value is 0<11. It seems that Excel treats 0 and an empty cell the same. Whatja think? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting Cells With Values 0 and Null
You can do what you want using these 3 Conditional Format formulas (assuming
A1 is the active cell when you create them)... Empty (Null) Condition: =A1="" Zero Condition: =A1=0 Range Condition: =AND(A10,A1<11) -- Rick (MVP - Excel) "Rookie Access User" wrote in message ... I want the background of a cell one color if it holds a value of 0, another color if it is null or empty, and another color if the value is 0<11. It seems that Excel treats 0 and an empty cell the same. Whatja think? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting for Values in 3 cells | Excel Worksheet Functions | |||
| Conditional Formatting of cells containing interger values | Excel Discussion (Misc queries) | |||
| Conditional Formatting of Cells with Multiple Cell Values | Excel Discussion (Misc queries) | |||
| Conditional Formatting on Null Value | Excel Worksheet Functions | |||
| cntrl + down arrow and null values in cells | Excel Discussion (Misc queries) | |||
Linear Mode
