Cell color

[rkawasak]

I would like to set colors to cells based on their values. If below or equal to 10, red. If between 10 and 70, yellow. If above or equal to 70, green. I tried using the Conditional Formatting feature, but all the blank cells in the range were colored red. The blank cells need to remain white. Any help will be greatly appreciated.

[Mark W.]

On 2002-04-23 09:33, rkawasak wrote:
I would like to set colors to cells based on their values. If below or equal to 10, red. If between 10 and 70, yellow. If above or equal to 70, green. I tried using the Conditional Formatting feature, but all the blank cells in the range were colored red. The blank cells need to remain white. Any help will be greatly appreciated.

For the red condition use...

=AND(LEN(A1)>0,A1<=10)

[Jay Petrulis]

Conditional formatting

Condition 1
Formula Is
=AND(NOT(ISBLANK($A$1)),$A$1<=10)

Condition 2
Formula Is
=AND($A$1>10,$A$1<=70)

Condition 3
Formula Is
=AND($A$1>70,ISNUMBER($A$1))

Format to suit.

Bye,
Jay

[TresGay]

Hi Rk,

Based on what you posted, if I was the computer I would have coloured the blank cells red as well You need to tell the conditional formatting at what point below 10 you want the cell to be white.

You said 10 and below or:
=> 10 RED so Null (blank) cells will be RED.

You might try a between statement in your conditional formatting. All cells BETWEEN .0000001 and 10 will be RED (this assumes that you will never have an amount less than .0000001).

Take care,
Tres

[rkawasak]

Thanks guys! Problem solved. Really appreciated the quick response, wow!