Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formating - Help | Excel Worksheet Functions | |||
conditional formating | Excel Discussion (Misc queries) | |||
Conditional Formating | Excel Discussion (Misc queries) | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Conditional Formating | Excel Discussion (Misc queries) |