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...
 
Back
Top