Actually, you won't need anything in Column B. All of your conditions can be
met just with Conditional Formatting in Column A.

Use these 3 formulas:

=OR(A1<=4499,A1=11001)

=OR(AND(A1=4500,A1<=6699),AND(A1=10001,A1<=11000 ))

=AND(A1=6700,A1<=10000)

HTH,
Elkar

"meandmyhorse" wrote:


I have searched all over and can't find an answer to this....

I want to color a cell depending on variables. I have 5 variables, so
unfortunately, conditional formatting won't work, what I did was create
an IF statement to get the variables down to 3 in the adjacent cell.
But when I go back in to conditional formatting, what formula do I use
to look at the adjacent cell?

i.e. Depending on what number is typed in A1...A2 can equal G, Y, or
R. I can build the three conditional formats to color G,Y,R the way I
want...but I can't figure out what the formula is to look at A2 to
determine it's value.

Cell A1 Cell A2
11455 G

Or is there another way to utilize conditional formatting when I have
the following variables...

11001 = R
10001 - 11000 = Y
6700 - 10000 = G
4500- 6699 = Y
<4499 = R

Mucho Gracia to anyone who might be able to help!!! :)


--
meandmyhorse
------------------------------------------------------------------------
meandmyhorse's Profile: http://www.excelforum.com/member.php...o&userid=31689
View this thread: http://www.excelforum.com/showthread...hreadid=513872