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?

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?

How about you also set the font color to gray?


Gord Dibben MS Excel MVP

On Wed, 5 Dec 2007 14:25:01 -0800, roxiemayfield
wrote:

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?

That did it - thank you so much!

"Bernard Liengme" wrote:

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?

Your original requirement was to hide if <0

Bernard's suggestion to uncheck "zero values" won't do that.

That won't hide values that are <0 but are formatted to show 0


Gord Dibben MS Excel MVP


On Thu, 6 Dec 2007 10:14:01 -0800, roxiemayfield
wrote:

That did it - thank you so much!

"Bernard Liengme" wrote:

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?