Conditional Formatting

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

Guest

I have an Excel Workbook with conditional formatting to hide zeros. The
zeros are hidden on screen but they show up when I print (I want them to be
hidden when I print as well). Please help!
 
The better way to hide zeros is:

Tools > Options > View and then clear the Zero Values checkbox.
 
Thanks Gary''s Student! This helps for the acutal "0" fields but I also have
some that are 0.00%, 100% (due to a formula but I don't want it to show
unless it's less than 100%), 01/00/00 (date due to formula as well). This
same document used to not have this problem. I don't know what changed
though...
 

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

Excel Highlighting duplicates 0
Excel Conditional Formatting Removal 7
Word Conditional Formatting in Word 0
Excel Conditional Formatting 1
Reclac Conditional Formatting 1
Excel conditional formatting with Weeknum 4
Conditional Formatting and VBA 4
Conditional Formatting 1

Back
Top