Conditional Formating: Highlight Cells Based on Text of Another Cell

Hey everyone, I've been trying to figure out how to do this certian function for the last hour, with no real progress. I appologize if this is in the wrong section. What I'm trying to do is this:

I have created a drop down box that allows me to choose multiple different Text Options.

Example: Cell B4 has dropdown that lets me choose the Text Options, "House", "Car" and "Truck".

Next, I have 5 or so other columns underneath with their own text. What I want to do is have different cells highlight themselves depending on what is in Cell B4.

Example, if "House" is selected in B4, I want cells B7 and B9 to highlight. If "Car" is selected, I want cells B7, B8, and B10 to highlight. If "Truck" is highlighted, I want cells B9-B11 to highlight.

Is this possible to do? I've tried using If/Then statements, but those don't seem to work for this type of thing.

Any help would be greatly appreciated. Also, I am using Excel 2007.

Select B9:B11 and invoke Conditional Formatting from the Home Ribbon menu...

Click New Rule and choose Use a formula to determine which cell to format

enter formula

=$B$4="Truck"

Choose format and pick colour from Fill tab..

Click Ok...and Click to close.

Now choose B7, B8 and B10

Repeat above steps, using formula =$B$4="Car"

Repeat again, choosing B7 and B9 with formula =$B$4="House"

Please 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