View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
PT PT is offline
external usenet poster
 
Posts: 17
Default Another Conditional Format Question

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.

--
PT