Conditional Formatting

[Loren]

I'm trying to set up 3 different formats:
#1 If a value is less than 800 I want the pattern Green
#2 If this value is between 500 & 200 I want the pattern Yellow
#3 If this value is less than 200 I want the pattern Red

Since all these values are less than 800 it just turns the pattern Green but
will not go to the other 2 colors regardless if I use the "Not Between"
function or any of the others I've tried. Open for suggestions.

 

[Simon Lloyd]

you need to set it up like this
#1 If a value is between than 501 and 800 I want the pattern Gree
#2 If this value is between 500 & 200 I want the pattern Yello
#3 If this value is less than 200 I want the pattern Re

I'm trying to set up 3 different formats
#1 If a value is less than 800 I want the pattern Gree
#2 If this value is between 500 & 200 I want the pattern Yello
#3 If this value is less than 200 I want the pattern Re

Since all these values are less than 800 it just turns the patter
Green bu
will not go to the other 2 colors regardless if I use the "Not Between
function or any of the others I've tried. Open for suggestions
-
Thanks, Lore

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com

 

[Teethless mama]

try to switch #3 to #1, and #1 to #3

 

[MyVeryOwnSelf]

I'm trying to set up 3 different formats:

#1 If a value is less than 800 I want the pattern Green
#2 If this value is between 500 & 200 I want the pattern Yellow
#3 If this value is less than 200 I want the pattern Red

This works for me with Excel 2003.

Condition 1: Cell value is less than 200 >> Format Red

Condition 2: Cell value is less than 500 >> Format Yellow

Condition 3: Cell value is less than 800 >> Format Green

Depending on the need, "less than or equal to" might be called for instead
in one or more of these.

Modify to suit.