Re: Conditional Formatting With Grades
- From: SteveG <SteveG.28y31p_1149537304.2853@xxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 5 Jun 2006 14:54:14 -0500
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?action=getinfo&userid=7571
View this thread: http://www.excelforum.com/showthread.php?threadid=548704
.
- Follow-Ups:
- Re: Conditional Formatting With Grades
- From: november678x
- Re: Conditional Formatting With Grades
- References:
- Conditional Formatting With Grades
- From: november678x
- Conditional Formatting With Grades
- Prev by Date: Re: A validated List which link to selected cells according to what is selected on the list
- Next by Date: Re: Lookup multiple workbooks
- Previous by thread: Conditional Formatting With Grades
- Next by thread: Re: Conditional Formatting With Grades
- Index(es):
Relevant Pages
|
