Conditional Formatting - Hiding Rows

[ganrg]

Is it possible to hide a row based on a conditional format?

If I had the list:

Name Age
Andrew 15
Brad 8
Charles 4
David 20
Elvis 5

If I format conditionally to make the text white (i.e. hidden when
reading or printing) for all people over age 10, then I will be left
with the following list:

Name Age
Andrew 15
Brad
Charles
David 20
Elvis

How can I get my conditionally fomatted list to look like:

Name Age
Andrew 15
David 20

without doing any manual formatting after the conditional formatting?

 

[John Wilson]

ganrg,

You can use an AdvancedFilter to weed out what you want to.

Take a loog at Debra's site for some help on doing this both
manually and via VBA:

http://www.contextures.com/tiptech.html
Look at Advanced Filter & Criteria, AutoFilter and AutoFilter Programming.

John