Conditional Formatting IS working
The zero display is not part of Cond Formatting
Have you tried Tools | Options | Views - in lower part of dialog look for
Window Options and uncheck Zeros Values
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"roxiemayfield" wrote in message
...
I have an employee weekly schedule and have set up 52 weeks (worksheets). I
have the schedule set up to copy from the previous week.

The conditional format is if the value of a cell is < 0, I want the cell
to
format to gray pattern. It does format gray but it puts in .00. I do not
want
a 0 or a dash - just for the cell to be gray. Can I do this?