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

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

It seems to me that you have used CF only with the Cell Value Is
option. There is a Formula Is choice where you enter a formula that
evaluates to true/false. This feature is the one of choice when we want
to base formatting on the values of other cells.

In there you can use the formulas suggested by Elkar.

HTH
Kostis Vezerides