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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting based on formula cell 4
Another Conditional Format Question 3
Conditional format 1
conditional formatting update issue 5
Editing conditional formats (Excel 2010) 15
Conditional Formatting with VBA 4
conditional format on first & last digit on 3 digit cell data 3
Conditional Formatting Formula 2

Top