| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Conditional Format Question
Suppose I have a cell or range of cells (formula or constant) formatted for
numeric appearance, say two digit decimal. How would I apply conditional formatting to show the cell(s) as blank when its value = zero? -- PT |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Conditional Format Question
Using Conditional Formatting:
CF1: Cell value is equal to 0 Format1: <font/<same color as background Better: Use Custom Formatting: Format/Cells/Number/Custom 0.00;-0.00;;@ In article , "PT" wrote: Suppose I have a cell or range of cells (formula or constant) formatted for numeric appearance, say two digit decimal. How would I apply conditional formatting to show the cell(s) as blank when its value = zero? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional format question | Excel Worksheet Functions | |||
| question about conditional format | Excel Discussion (Misc queries) | |||
| Conditional format question | Excel Discussion (Misc queries) | |||
| Conditional Format Question | Excel Worksheet Functions | |||
| Another Conditional format question | Excel Worksheet Functions | |||
Hybrid Mode
