I am trying to format a worksheet of students and their test results. We have 3 categories of achievement we are trying to track and I want to highlight each level. If a student passed the academic component of testing, I want the row of cells their name & test results are located in to show up with all the font green. If they passed the industry certification component of their testing, I want the row of cells to show up with blue font. If they received a score of 70 or above and 75 or above on two different components, I want them to show up with green font, green fill.

I feel like there is an easy way to do this but I just can't figure it out with the preset conditional formatting rules--maybe I"m just not trying the right one.

Help!