Excel 2007 : Conditional Formatting for Multiple Columns

Good morning - I am stuck on trying to figure out how to conditionally format one column if two critera are met.

I need to be able to highlight the entire row IF the sq ft % is 90% or greater AND the units column is 5 more units.

Units Unit Sq Footage Sq Ft %
5 425 92.6%
1 100 90.0%
3 375 95.8%
7 800 92.8%

I have been reviewing forums and can't find the formula that would fit correctly. I would appreciate any help that I can get on this. Thank you for reviewing.

Select A2:C5 and go to Home|Conditional Formatting|New Rule

Select Use a formula to determine which cells to format

Enter formula: =AND($A2>=5,$C2>=90%)

Format.

Please remember to mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save