If statements and conditions - again!! new prob

[Guest]

Hey Max, thanks for your help.

The formulas you gave ie

Formula is: =AND(B2-A2<=0,B2<>"",A2<>"")
Format: Red fill

worked fine. thank you.
Now my prob is my data is not all numerical, ie it runs
6a,6b,6c....to...1a,1b,1c where 6a is highest and 1c is lowest. So excel
cna't use formula where letters are involved. I can change the 1c, 1b etc
into average point scores instead. i.e 1c=7, 1b=9,1a=11 etc. But I wanted
Excel to do it so if a member of my staff types in 1c, the cell displays 7
adn if they type in 4a the cell will display 29 etc. I tried autocorrect, but
every cell needs every possibility...does this make sense? Really appreciate
your help. - Bob

 

[Bob Phillips]

You could still use that formula

1a is less than 1b, and
1c is less than 2a

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[Don Guillett]

Difficult to tell what you are doing since you did NOT stay in the original
thread.
You can use MATCH, LOOKUP, CHOOSE formulas

=MATCH(B12,{"6a","6b"})