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