![]() |
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? |
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