View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LisaVH LisaVH is offline
external usenet poster
 
Posts: 12
Default zero as data value

I have a spreadsheet I use to track production of a given facility. Some
facility's production is zero. I want to make a distinction between zero
production and a blank cell. Is this possible? I run a conditional format
to tell me when data is missing, however it sees the zero values the same as
a blank cell.