Using Excel 2003
I have a range of cells from A1 to A20 that has conditional formmating. If
someone enters a number from zero to 4.5, the background turns green. The
problem is, before someone even enters a number, the background is green. Why
is this? I don't want to confuse the data entry person. I have 2 other
conditions in those cells that turn the cells yellow and red when other
values are entered. How can I get rid of the green background?
Thank you, Karen

You don't tell us how you're filling with green. Perhaps you've set the
conditional formatting to fill with green if nothing is entered.

Tyro

"Karen" wrote in message
...
Using Excel 2003
I have a range of cells from A1 to A20 that has conditional formmating. If
someone enters a number from zero to 4.5, the background turns green. The
problem is, before someone even enters a number, the background is green.
Why
is this? I don't want to confuse the data entry person. I have 2 other
conditions in those cells that turn the cells yellow and red when other
values are entered. How can I get rid of the green background?
Thank you, Karen

Thank you for responding. When you select a range of cells and open
conditional formatting and set the condition to "Cell Value is" - "Between" -
I entered the minimum value as 0 and the maximum value as 4.5. Now before I
even enter a numerical value in any one of those cells, that has conditional
formatting applied, the background is green.
Hope this helps - Thanks, Karen

"Tyro" wrote:

You don't tell us how you're filling with green. Perhaps you've set the
conditional formatting to fill with green if nothing is entered.

Tyro

"Karen" wrote in message
...
Using Excel 2003
I have a range of cells from A1 to A20 that has conditional formmating. If
someone enters a number from zero to 4.5, the background turns green. The
problem is, before someone even enters a number, the background is green.
Why
is this? I don't want to confuse the data entry person. I have 2 other
conditions in those cells that turn the cells yellow and red when other
values are entered. How can I get rid of the green background?
Thank you, Karen

That's your problem. A blank cell is the same as 0 in conditional
formatting. Change the condition to greater than 0 and less equal 4.5.

Tyro

"Karen" wrote in message
...
Thank you for responding. When you select a range of cells and open
conditional formatting and set the condition to "Cell Value is" -
"Between" -
I entered the minimum value as 0 and the maximum value as 4.5. Now before
I
even enter a numerical value in any one of those cells, that has
conditional
formatting applied, the background is green.
Hope this helps - Thanks, Karen

"Tyro" wrote:

You don't tell us how you're filling with green. Perhaps you've set the
conditional formatting to fill with green if nothing is entered.

Tyro

"Karen" wrote in message
...
Using Excel 2003
I have a range of cells from A1 to A20 that has conditional formmating.
If
someone enters a number from zero to 4.5, the background turns green.
The
problem is, before someone even enters a number, the background is
green.
Why
is this? I don't want to confuse the data entry person. I have 2 other
conditions in those cells that turn the cells yellow and red when other
values are entered. How can I get rid of the green background?
Thank you, Karen

But sometimes the value will be entered as zero
Karen

"Tyro" wrote:

That's your problem. A blank cell is the same as 0 in conditional
formatting. Change the condition to greater than 0 and less equal 4.5.

Tyro

"Karen" wrote in message
...
Thank you for responding. When you select a range of cells and open
conditional formatting and set the condition to "Cell Value is" -
"Between" -
I entered the minimum value as 0 and the maximum value as 4.5. Now before
I
even enter a numerical value in any one of those cells, that has
conditional
formatting applied, the background is green.
Hope this helps - Thanks, Karen

"Tyro" wrote:

You don't tell us how you're filling with green. Perhaps you've set the
conditional formatting to fill with green if nothing is entered.

Tyro

"Karen" wrote in message
...
Using Excel 2003
I have a range of cells from A1 to A20 that has conditional formmating.
If
someone enters a number from zero to 4.5, the background turns green.
The
problem is, before someone even enters a number, the background is
green.
Why
is this? I don't want to confuse the data entry person. I have 2 other
conditions in those cells that turn the cells yellow and red when other
values are entered. How can I get rid of the green background?
Thank you, Karen

Maybe you could use:
Formula is:
=and(isnumber(a1),a1=0,a1<=4.5)

Karen wrote:

But sometimes the value will be entered as zero
Karen

"Tyro" wrote:

That's your problem. A blank cell is the same as 0 in conditional
formatting. Change the condition to greater than 0 and less equal 4.5.

Tyro

"Karen" wrote in message
...
Thank you for responding. When you select a range of cells and open
conditional formatting and set the condition to "Cell Value is" -
"Between" -
I entered the minimum value as 0 and the maximum value as 4.5. Now before
I
even enter a numerical value in any one of those cells, that has
conditional
formatting applied, the background is green.
Hope this helps - Thanks, Karen

"Tyro" wrote:

You don't tell us how you're filling with green. Perhaps you've set the
conditional formatting to fill with green if nothing is entered.

Tyro

"Karen" wrote in message
...
Using Excel 2003
I have a range of cells from A1 to A20 that has conditional formmating.
If
someone enters a number from zero to 4.5, the background turns green.
The
problem is, before someone even enters a number, the background is
green.
Why
is this? I don't want to confuse the data entry person. I have 2 other
conditions in those cells that turn the cells yellow and red when other
values are entered. How can I get rid of the green background?
Thank you, Karen








--

Dave Peterson

In CF, use not "Cell Value Is", but "Formula Is":
=AND(A1<"",A1=0,A1<=4.5)
--
David Biddulph

"Karen" wrote in message
...
But sometimes the value will be entered as zero
Karen

"Tyro" wrote:

That's your problem. A blank cell is the same as 0 in conditional
formatting. Change the condition to greater than 0 and less equal 4.5.

Tyro

"Karen" wrote in message
...
Thank you for responding. When you select a range of cells and open
conditional formatting and set the condition to "Cell Value is" -
"Between" -
I entered the minimum value as 0 and the maximum value as 4.5. Now
before
I
even enter a numerical value in any one of those cells, that has
conditional
formatting applied, the background is green.
Hope this helps - Thanks, Karen

"Tyro" wrote:

You don't tell us how you're filling with green. Perhaps you've set
the
conditional formatting to fill with green if nothing is entered.

Tyro

"Karen" wrote in message
...
Using Excel 2003
I have a range of cells from A1 to A20 that has conditional
formmating.
If
someone enters a number from zero to 4.5, the background turns
green.
The
problem is, before someone even enters a number, the background is
green.
Why
is this? I don't want to confuse the data entry person. I have 2
other
conditions in those cells that turn the cells yellow and red when
other
values are entered. How can I get rid of the green background?
Thank you, Karen