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.

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.

Lisa,

You don't say what "run a conditional format" is in this case. If you're
using Format - Conditional Formatting to highlight empty cells, try this.
It will not highlight a zero cell, but will highlight an empty cell.

Select the cells. Note the active (white) cell of your selection
Format - Conditional formatting
Select "Formula is:" =C1="" Include both quote marks. In this case,
C1 is the active cell.
Click Format and set the formatting you want to indicate an empty cell.
OK
OK

OK?
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"LisaVH" wrote in message
...
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.