M
meandmyhorse
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...
6700 - 10000 = G
4500- 6699 = Y
<4499 = R
Mucho Gracia to anyone who might be able to help!!!
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...
10001 - 11000 = Y11001 = R
6700 - 10000 = G
4500- 6699 = Y
<4499 = R
Mucho Gracia to anyone who might be able to help!!!