Ranges within Conditional Formatting

R

Ryno

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?
 
G

Gordon

Ryno said:
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?
Click to expand...

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

Gordon

Ryno said:
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?
Click to expand...

Unfortunately you are limited to 3 conditions!
 
J

Jason Morin

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($A1>100,$A1<=105))

Red:

=OR($A1<90,$A1>105)

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

HTH
Jason
Atlanta, GA
 
D

Debra Dalgleish

Select the cells that you want to format
Choose Format>Conditional 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
 
Top