Help Needed on Conditional Formatting

[szpt9m]

Hi All,

I have 5 values as in the order given below from lower to higher order(PQ is lower value, then Q,B,S and finally G is the higher value.)

PQ
Q
B
S
G

in column A and column B the values are entered in some order..
for ex

ColA	ColB
PQ	PQ
B	PQ
S	S
Q	B
G	G

Now the resultant color using conditional formatting i need is as below:

For rows[conditional formatting is for ColB values]
1: Since PQ is equal to PQ it should be Green
2: Since PQ is less than B, ColB 2nd cell be highlighted in Red
3: Since S equal to S, ColB 3rd cell be highlighted in Green
4: Since B is greater than Q, ColB 4th cell be highlighted in Green
5: Since G is equal to G, ColB 5th cell be highlighted in Green

So Ultimately, if the value is ColB is greater than or equal to the adjacent value in ColA it should be highlighted in Green else it should be highlighted in Red.

Please note here that, the values entered here are not numbers, instead letters like PQ,Q,B,S and G as shown in above example..

Please help me.

Thank you.

[loginjmor]

Hi -

Attached is a spreadsheet that will do what you want. Basically just assigned a rank number to each alpha coding and compare ranks for conditional formatting.

Hope this helps.

[szpt9m]

Hi -

Attached is a spreadsheet that will do what you want. Basically just assigned a rank number to each alpha coding and compare ranks for conditional formatting.

Hope this helps.

Thanks a lot.. working as expected