ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Override No Zero Values ? (https://www.excelbanter.com/excel-programming/329706-override-no-zero-values.html)

Al Franz

Override No Zero Values ?
 
Have a spreadsheet set in OPTIONS to not show zero values. Would like
zero's to show on a few select cells though, is that possible, keeping the
majority of the spreadsheet not showing zero values?



Bob Phillips[_7_]

Override No Zero Values ?
 
You could have conditional formatting that sets the font colour to white if
zero, but not for certain cells.


--
HTH

Bob Phillips

"Al Franz" wrote in message
...
Have a spreadsheet set in OPTIONS to not show zero values. Would like
zero's to show on a few select cells though, is that possible, keeping the
majority of the spreadsheet not showing zero values?






All times are GMT +1. The time now is 07:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com