| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional format if cell value 0 pattern red value blank nothing
I tried conditional formatting. If cell value 0 pattern red color. If cell
value blank no changes. I have entire column with value some 0 value some blank. conditional format equal to 0 pattern red is working fine but blank cell also replacing with red color. I dont want blank cell to replace. I want blank cell as it is. Any way...... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional format if cell value 0 pattern red value blank nothing
Excel often evaluates these to be the same. You will need to change
the CF conditions to Formula Is rather than Cell Value Is, then enter this formula: =AND(ISNUMBER(A1),A1=0) assuming the cell is A1. Hope this helps. Pete On Nov 1, 11:32 am, Matt wrote: I tried conditional formatting. If cell value 0 pattern red color. If cell value blank no changes. I have entire column with value some 0 value some blank. conditional format equal to 0 pattern red is working fine but blank cell also replacing with red color. I dont want blank cell to replace. I want blank cell as it is. Any way...... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional format if cell does not display a blank | Excel Worksheet Functions | |||
| Conditional Format A Cell If Row Is Blank | Excel Discussion (Misc queries) | |||
| Recognition of color pattern in cells to use in Conditional format | Excel Discussion (Misc queries) | |||
| To format a cell pattern by VBA | New Users to Excel | |||
| Conditional Format to highlight blank cell | Excel Worksheet Functions | |||
Hybrid Mode
