Conditional Formatting

[NicoleI]

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!

 

[Gary''s Student]

The better way to hide zeros is:

Tools > Options > View and then clear the Zero Values checkbox.

 

[NicoleI]

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