LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
conditional format question Anthony Excel Worksheet Functions 4 March 8th 07 08:17 PM
Conditional Format Question Karl Excel Discussion (Misc queries) 5 January 11th 07 11:55 PM
Conditional format question Richard Excel Discussion (Misc queries) 6 September 30th 06 01:19 AM
Conditional Format Question carl Excel Worksheet Functions 3 June 28th 06 03:42 PM
Conditional format question [email protected] Excel Discussion (Misc queries) 7 September 16th 05 04:15 PM


All times are GMT +1. The time now is 01:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"