Conditional Formating
 

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

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

Conditional Formating
 

Ooops!

You wanted to format the test scores in column C.

Select the range of cells B1:B10

So, that should be:

Select the range of cells C1:C10

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
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