Thread: [Solved] Zero (0) in cell
View Single Post
 
Old 01-18-2011, 07:17 PM
Kaneto Kaneto is offline Windows 7 Office 2010 (Version 14.0)
Competent Performer
 
Join Date: Nov 2010
Posts: 136
Kaneto is on a distinguished road
Default

You should be able to do it with Conditional Formatting.

Basically, select the entire worksheet, then click Format > Conditional Formatting.
For the condition, it will be When Cell Value Equals 0
Then for the formatting when the condition is true, just make the text white. The zero will still be there, but it wont be viewable against the white background.

-SW
Reply With Quote