Hi,

I just can't see CF treating a blank cell and a cell with 0 value the same.
What formula are you using for the production values??

Regards
Jean-Guy

"LisaVH" wrote:

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.