Conditonal Formatting

[rideanon]

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!

[pike]

Hello rideanon,
Welcome to the forum
Signal > 0.7 - fail
You can use the if function
eg..
where a1=Signal a2=1.57

a3 = if (a2>0.7,"Fail","")

[rideanon]

thank you for the welcome pike.
I will share what I ended up doing to takle this problem so I can hopefully help someone in the future.
To keep this simple I will refer to the example I provided above.
I created 3 different conditional formatting rules by clicking on the conditional formatting tab - going down to new rule - and going down to "use a formula to determine which cells to format"
The three equations i used are as follows
=AND($A1="signal",$B1>=0.7)
=AND($A2="2-way stop",$B1>=0.3)
=AND($A1="4-way stop",$B1>=0.6)

select your format color you want to fill the boxes with and hit ok. then you will see next to your rule a tab that says "Applies to". Select all of the data that you want to check for these conditions and be highlighted.