I have a problem that I need to get resolved as soon as possible and need
help. I have created a tracking sheet for some stock investments I have.
The web site I use for information is a pay site that uses alpha and numeric
characters to show strength and weakness. I have no problem with the number
part of this, but the alpha part is driving me crazy. I need to have the
alpha characters in the following sequence of order. A+, A, A-, B+, B, B-,
C+, C, C-, etc...., but when I use the same =AND formula that I use for the
numbers the sequence comes out like this. A+, A-, A, B+, B-, B, etc.... I
am shading the cell red if the number or letter decreases, green if it
increases and yellow if it stays the same. Since A is suppose to follow A+
and be higher in ranking than A- it should show green if A- was in the cell
above it in the column and it doesn't it shows red as if it were a worse
rating. Can someone help me figure this out???? Thanks in advance for your
time.