Conditional Formating: Highlight Cells Based on Multiple Stipulations

I'm trying to get it so that a cell becomes automatically highlighted if 2 other cells conditions are met. For example, I want cell A5 to become highlighted if BOTH cell B1=Loan 1 AND cell B5=Yes. Here is a mockup of what I'm talking about incase it makes it easier to understand.

I'm using Excel 2007.

Try
=(AND(B1="Loan",B5="Yes"))

and format as necesssary

(I havent looked at your file just your description)

In XL2007, chose B5:B10 if you want all cells to format on that condition,

then choose Conditional Formatting from Home tab... and then Manage Rules... then click New Rule... Select use a formula to determine which cells to format...

then apply: =AND($B$1="Loan 1",B5="Yes")

Click Format and choose colour

Click Ok.

Click New Rule to add more formatting or Ok to finish.