 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2007Another 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.  SignaturePT 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. > 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 [quoted text clipped - 5 lines] > In other words, the cells would normally show zero values, but could be > globally turned "blank" at my command. 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 > One way would be to add a switch to your condition in the CF. > [quoted text clipped - 21 lines] >> In other words, the cells would normally show zero values, but could be >> globally turned "blank" at my command. 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. [quoted text clipped - 10 lines] >> In other words, the cells would normally show zero values, but could be >> globally turned "blank" at my command.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.