Conditional format when autofilter engaged

  • Thread starter Thread starter ttbbgg
  • Start date Start date
T

ttbbgg

I have autofilter engaged. When I choose a filter from one of the columns,
I'd like to conditionally format the column to show in a color to further
denote it is the one currently on filter option.
Formula?
 
Roger;
This does look valuable, however creating a UDF is a little beyond me as it
seems to entail me creating my own initial filter logic rather than using the
autofilter available. Although I have reviewed and understand the concept I
was hoping for an easier way.
 
I looked further on the site, and the FilterColor.zip seemed to help me more
because I simply copy/pasted the VBA script into my own sheet. It's a
general script dependong on the Autofilter to be engaged, so it worked.
 
Back
Top