Conditional Format Question

  • Thread starter Thread starter PT
  • Start date Start date
P

PT

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?
 
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;;@
 
Back
Top