Conditional Formatting With Grades

[november678x]

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

 

[SteveG]

Use the Formula is option in Conditional Formatting. Say your grade
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 fo
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

Stev

 

[november678x]

It worked perfectly, Thank you!