Filter/Hide rows in a table based on drop-down selection?

1) Highlight C13:D21. It's important that when all those cells are highlighted, C13 is the cell listed in the NAME BOX (left of the Formula Bar) as the primary anchor selected cell.

2) Create a new Conditional Formatting Rule with following formula that changes the font to WHITE:
=AND($D$6>0, $C13>$D$6)

I created an area that would be automatically populated with the number of rows that you call for in cell D6. The data is drawn from your sample in C13:D21. In C26 enter and fill down:

Formula:

Please Login or Register  to view this content.

This is an Array Formula:...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

In D26 enter this formula and fill down:

Formula:

Please Login or Register  to view this content.

Here is your workbook. You can test it out to see how it works.

Thank you for the feedback.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.