Conditional formating

[gene]

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???

 

[Bob I]

use
=(B2="k")*(C2<10)

 

[db ´¯`·.. >]

asically it should be read from this:

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.

to something rationalized like this:

if (K<9, red, yellow)
if (F<24, red, yellow)

to make it functional try something like this
with the "if then" formula:

if k<9, 0, 1
if 1<24, 0, 1

then use conditional formatting
to paint the value/score red if the formula
produces 0 or yellow if the formula
produces a 1.


--

db·´¯`·...¸><)))º>
DatabaseBen, Retired Professional
- Systems Analyst
- Database Developer
- Accountancy
- Veteran of the Armed Forces
- @hotmail.com
"share the nirvana" - dbZen

~~~~~~~~~~~~~~~~~~