okay, so I have ZERO experience using excel...which still puts me at the "top of my class" among teachers at my school.

I'm now using it to make a school data wall - an excel file that has student name, DOB followed by various school assessments.

QUESTION ONE
I want to use the conditional formatting to highlight certain data - for example, I want anything in the D- to C+ range to be red, B- to B to be yellow and B+ to A+ to be green.

I can easily see how I would do this if the data was in percentages. you would just say that anything less than 70 is red, etc. however, excel doesn't know that a "B-" is less than a "B", etc.

the simple solution would be to convert the grades, which I would do if this was just for me. however, other teachers will be using this, and I want to keep it as simple as possible. I want them to type in D+ and have the cell go immediately red. I can do this, I just can't do the range, which is what I need. some users will be using open office or 2003 excel, which I believe only let you have 3 conditions (I may be wrong on this).

QUESTION TWO
we use the letter scale as well as a number scale going 0, 1, 1+, 2-, 2, 2+ etc all the way to 4+. yes, I realize this is exactly the same as using the letters, and just as inefficient. I did not choose it, vote for it, or endorse it. you can thank our government for the confusion!

I can't see how to let excel take in this data since it thinks that "1+" is the start of an equation. I have since learned that typing it in as...

'3+

will allow it to appear normal, but as I mentioned earlier, other teachers will be entering data, and I would like them to be able to simply type 3+ and be done with it.

once I am able to input these numbers, I will have the same problem as question one with needing to have excel understand the order.

thanks in advance to all you excel wizards out there! I look forward to reading your responses.