Within a cell, thisis basically what I want to do but am having trouble:
if the value is between 95-100 background = green
else if value is between (90-95) or between (100-105) background = yellow
else if value is <90 OR 105) background = red

Any ideas?

Ryno wrote:
Within a cell, thisis basically what I want to do but am having
trouble: if the value is between 95-100 background = green
else if value is between (90-95) or between (100-105) background
= yellow else if value is <90 OR 105) background = red

Any ideas?

If you click the "Add" button after having set the first condition, you can
then set other conditions.

Ryno wrote:
Within a cell, thisis basically what I want to do but am having
trouble: if the value is between 95-100 background = green
else if value is between (90-95) or between (100-105) background
= yellow else if value is <90 OR 105) background = red

Any ideas?

Unfortunately you are limited to 3 conditions!

Set your three conditions use "Formula Is" on the drop-
down arrow and use these 3 statements:

Green:

=AND($A1=95,$A1<=100)

Yellow:

=OR(AND($A1=90,$A1<95),AND($A1100,$A1<=105))

Red:

=OR($A1<90,$A1105)

This works for col. A. Change the cell reference if
needed.

HTH
Jason
Atlanta, GA

-----Original Message-----
Within a cell, thisis basically what I want to do but am
having trouble:
if the value is between 95-100 background = green
else if value is between (90-95) or between (100-
105) background = yellow
else if value is <90 OR 105) background = red

Any ideas?
.

Select the cells that you want to format
Choose FormatConditional Formatting
From the first dropdown, choose Formula Is
Type a formula that refers to the active cell
(its address is in the Name Box, to the left of the formula bar)
For example, if A1 is active: =AND(A1=95,A1<=100)
Click the Format button, and on the Pattern tab,
select the Green colour
Click OK
Click the Add button

From the first dropdown, choose Formula Is
Type a formula that refers to the active cell
For example, if A1 is active: =AND(A1=90,A1<=105)
Click the Format button, and on the Pattern tab,
select the Yellow colour
Click OK
Click the Add button

From the first dropdown, choose Formula Is
Type a formula that refers to the active cell
For example, if A1 is active: =ISNUMBER(A1)
Click the Format button, and on the Pattern tab,
select the Red colour
Click OK, click OK

Ryno wrote:
Within a cell, thisis basically what I want to do but am having trouble:
if the value is between 95-100 background = green
else if value is between (90-95) or between (100-105) background = yellow
else if value is <90 OR 105) background = red

Any ideas?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html