| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If/Vlookup override | Excel Worksheet Functions | |||
| Override a Formula | Excel Discussion (Misc queries) | |||
| Null values in charts and how to override the goal seek functionality | Charts and Charting in Excel | |||
| Cell Value Override | Excel Discussion (Misc queries) | |||
| How do I override a deletion box? | Excel Programming | |||
Linear Mode
