Another Conditional Format Question

[PT]

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.

 

[JE McGimpsey]

One way would be to add a switch to your condition in the CF.

For instance:

Define HideZero as True (Insert/Name/Define). Then change the CF to

CF1: Formula is =AND(A1=0,HideZero)
Format1: <font>/<backkground color

change HideZero to False (manually or by macro) to show the zero values.

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

 

[T. Valko]

Just to add to JE's reply...

change HideZero to False (manually or by macro) to show the zero values.

One way to do this would be to use a check box from the forms toolbar. Use
the linked cell as the "HideZero" switch.

Biff

 

[PT]

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

--