Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |