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

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?