chuggins143
Board Regular
- Joined
- Nov 10, 2009
- Messages
- 100
Hello all,
Okay, so I have a table with 100+ columns... I'm wanting to format the Header to a different color scheme when it has been filtered down so when I'm scrolling across I can readily see the column that has been filtered without having to look for that little "tree" icon. Started thinking conditional formatting, but how do you tell it what to look for to differentiate between filtered and unfiltered? ...then looked at doing a macro, but don't know the syntax to look at F. vs. unF. Anyone have a suggestion??
Thanks!
C
Okay, so I have a table with 100+ columns... I'm wanting to format the Header to a different color scheme when it has been filtered down so when I'm scrolling across I can readily see the column that has been filtered without having to look for that little "tree" icon. Started thinking conditional formatting, but how do you tell it what to look for to differentiate between filtered and unfiltered? ...then looked at doing a macro, but don't know the syntax to look at F. vs. unF. Anyone have a suggestion??
Thanks!
C