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.
--
Thanks, Loren

you need to set it up like this:
#1 If a value is between than 501 and 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
Loren;416572 Wrote:
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.
--
Thanks, Loren


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=115949

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


"Loren" wrote:

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.
--
Thanks, 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

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.