Selection in a drop down list to highlight corresponding row

Hi gang.
i have a spread sheet with data across the rows for different types of product.
I have made a drop down list for the product types.

How can i select an item in a drop down list and it highlight the row owned by the product type?

I've attached a sample file.

Hugh

Add another CF rule.

Select the *entire* range A4:G9 starting from cell A4.
Cell A4 will be the active cell. The active cell is the
one cell in the selected range that is not shaded. The
formula will be relative to the active cell.

Goto the Home tab>Styles>Conditional Formatting>
Manage rules>New rule>Use a formula to determine
which cells to format

Enter this formula in the box below:

=AND($A$1<>"",$A4=$A$1)

Click the Format button
Select the desired style(s)
OK out

You're welcome. Thanks for the feedback!