Select your range of cells.
From the Format Menu, select Conditional Formatting...
Change "Cell Value Is" to "Formula Is"
Enter the formula: =OR(A1="A+",A1="A",A1="A-",A1="B+",A1="B")
Set your format (Green Background)
Click ADD
Change "Cell Value Is" to "Formula Is"
Enter the formula: =OR(A1="B-",A1="C+")
Set your format (Yellow Background)
Click ADD
Change "Cell Value Is" to "Formula Is"
Enter the formula: =OR(A1="C",A1="C-",A1="D+",A1="D",A1="D-",A1="F")
Set your format (Red Background)
Click OK

I just assumed the range started at A1 for my example, if yours is
different, change the cell reference accordingly.

HTH,
Elkar


"november678x" wrote:


Hello to all,

I am trying to get conditional formatting to do the following with
grades:

If grades are A+, A, A-, B+, B format background to Green

If grades are B-, C+, format background to Yellow

If grades are C, C-, D+, D, D-, F format background to Red


Any help would be appreciated, Thank you :)


--
november678x
------------------------------------------------------------------------
november678x's Profile: http://www.excelforum.com/member.php...o&userid=23641
View this thread: http://www.excelforum.com/showthread...hreadid=548704