View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default 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?