Looking for way to conditionally format header column when column is autofiltered

[LAAdams17]

Is there a way to conditionally format the column header (typically Row A (+column#)) when the column is autofiltered?

If not possible with conditionally formatting, VBA is also an option but conditional formatting is preferred.

Thank you!

 

[63falcondude]

You can Conditionally Format all of the column headers when a filter is applied if that helps.

To do this, highlight the column headers and use the CF formula =SUBTOTAL(3,A:A)<>COUNTA(A:A)

 

[LAAdams17]

Thank you. I saw that posted somewhere else, but I'm just looking to conditionally format the specific column(s) name(s) when used to autofilter.