Conditional Formatting With Grades
 

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

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

Conditional Formatting With Grades
 

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


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=548704

Conditional Formatting With Grades
 

It worked perfectly, 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