I need some help setting up an equation for my excel spreadsheet. To make it basic I have a column of traffic crash rates and a column with the type of intersection. Each intersection has a variable which will say wether it passes or not and i would like to have the columns that do not pass highlight themselves. Looks something like this.

control type Crash Rating
Signal 1.57
2-way stop 0.96
4-way stop 0.34

Provisions
Signal > 0.7 - fail
2-way > 0.3 - fail
4-way > 0.6 - fail

Thank you very much for your help!