Conditional Format Question

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?
 
J

JE McGimpsey

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