excel - Highlighting a row based on 3 columns of independent criteria -

I am trying to figure out how to do this job. I am making the Excel 2010 Windows 7 spreadsheet which needs to include 3 criteria specifically based on the school-wide benchmark: grade-level 5, subject-Math or Reading, and percentage score. I want to use 3 or 4 colors (red, yellow, green and hopefully a fourth color of blue) to show an "if-then" statement that will highlight the whole line in a particular color, To indicate how a child has done a benchmark

then the color should be based on grade level, subject and percentage. The three criteria are independent of each other, so for mathematics, 1% will be 60% yellow in mathematics, but reading can be 60% green for 2 GDRs. Or it may be 60% yellow in mathematics for 1 percent, but 60% of the readings may be green, all 3 criteria are independent from the rest. I hope that I tell you correctly.

For example: If a student's score in grade level 4 is greater than or equal to 90%, then the entire row is highlighted in green. So I need to include a cell for 3 columns: the number of grades (number), subject (word), and percentage (percentage with%) depending on the percentages. If a student gets a 45% score in the third grade, then the full line highlighted in red.

I am playing with conditional formatting, but I can not get it at all How to do all this work Any help would be greatly appreciated because I am trying to play my hair with this And I have failed miserably. My success kept me in red!

Thanks

What have you already achieved?

Do you have some lookup tables, where you can find scores, specific to the topic?

Perhaps you can add a (hidden) column sheet where you put the result of the lookup formula and base style on that result.

Otherwise, you can define a function / macro that gives a color string or even color.