Beautiful - I never noticed this switch after using Excel for only14 years!

--

OTOH, if you want to hide ALL zero values, it's probably easier to just
uncheck the Tools/Options/View/Zero Values checkbox.

In article , "PT"
wrote:

I've formatted a number of cells so that their contents "go blank" if the
cell value is zero, but display with their values otherwise. The "blank
is
accomplished by setting the font color to "white".

Now is there either a conditional formatting or macro trick which would
enable me to only apply globally the conditional formatting when I want
it?

In other words, the cells would normally show zero values, but could be
globally turned "blank" at my command.