Conditional Formating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a sheet that has conditional formatting on it. My problem is when
there should be a 0 it will not list it as a 0 but a blank. When there is a
blank cell it is shown as blank. Is there a way without messing up or having
to redo my conditioanl formatting when I want a 0 to be 0 and not blank?
 
Under 'tools'...'options'....'view'.....window options do you have a check
mark besides 'zero values'? If not click a check mark in that box.
 
You must log in or register to reply here.

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 1
Conditional Formatting 4th Condition 3
Formula than understands midnight? 25
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Comparison of columns using Conditional Formatting 3
conditional format if cell value 0 pattern red value blank nothing 1
Conditional formatting 2
conditional formatting update issue 5

Back
Top