Conditional Formatting With Grades

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
>
>

Use the Formula is option in Conditional Formatting. Say your grades are in column A then in A1,

First Condition

=MATCH(A1,$H$1:$H$5,0) ---Format as desired, click OK then ADD

Second Condition

=MATCH(A1,$I$1:$I$2,0) ----Format as desired, click OK then ADD

Third Condition

=MATCH(A1,$J$1:$J$6,0) ----Format as desired, click OK, and OK.

This is assuming your grade values for each condition are in H1:H5 for the first, I1:I2 for the second and J1:J6 for the third.

You could also use Function is and something like:

=OR(A1="A",A1="A+",A1="A-",A1="B+",A1="B")

Add for each condition.

Copy this formatting to the rest of the cells you want to apply it to.

HTH

Steve

It worked perfectly, Thank you!