Conditional Formatting - Hiding Rows

I have about 30 rows that I would like to conditionally format such that only rows that are populated with values appear. The items in these rows change dynamically as you select different categories contained in a drop down box.

Thx!!!

Conditional formatting cannot hide rows (or columns). It would require VBA. If you want to persue that, please start a thread in the Programming forum, and explain exactly what you want.