Conditional Formating
You have an overlapping condition:
K then a score of 0-9 is Red.
K and the score is 9-15 then the color is yellow
I'll asume the criteria a
0-9 RED
10-15 YELLOW
Assume the data to format is in the range B1:B10
Select the range of cells B1:B10
Goto the menu FormatConditional Formatting
Condition 1 - Red
Select the Formula Is option
Enter this formula in the box on the right:
=OR(AND(B1="K",COUNT(C1),C1=0,C1<=9),AND(B1=1,COU NT(C1),C1=0,C1<=24))
Click the Format button
Select the desired style(s)
OK
Click the Add button
Condition 2 - Yellow
Select the Formula Is option
Enter this formula in the box on the right:
=OR(AND(B1="K",COUNT(C1),C1=10,C1<=15),AND(B1=1,C OUNT(C1),C1=25,C1<=50))
Click the Format button
Select the desired style(s)
OK out
--
Biff
Microsoft Excel MVP
"gene" wrote in message
...
Please Help. I am a teacher of grades K and 1st. I have all of my
students
listed in column A There Grade K or 1 in Column b. I have the test that
I
have given in Column C. I wish to conditional format the scores of the
test
based on the grade. EXAMPLE If you are in K then a score of 0-9 is Red.
If
you are in 1st the the score 0-24 is red. If you are in K and the score
is
9-15 then the color is yellow. If you are 1st then the score 25-50 is
yellow.
I have a small idea that the formula might look something like if b2="k"
and
<9 true???
Can any one help?
--
g
|