Hi,

I'm looking to expand/hide rows that have been grouped (Data tab, Outline section, Group). What I really want is to be able to group rows, and name them because I have multiple groups I need control over. Then have them expand or hide based on a cell value. For example I want to group row 10 to 20, and if b6 = "Blue" have the rows expand if not have them hidden. Hopefully someone can help me with this I'm not having any luck with google.

Thanks
Dave