Illustrating the Column Being Sorted via AutoFilter in a Large spreadsheet that

[Jungle Fever]

I have a very large spreadsheet Is there a Macro that is able to ILLUSTRATE which column is using the Sort feature within AutoFilter e.g. Asceding Descending

Thanks JF

 

[Akashwani]

Hi JF,

I found the following solution HERE

In a standard module put this....

Function FilterOn(myCell As Range) As Boolean
    On Error Resume Next
    With myCell.Parent.AutoFilter
        With .Filters(myCell.Column - .Range.Column + 1)
            If .On Then FilterOn = True
        End With
    End With
End Function

Highlight your header row, say A1:G1 in 2007 go to Conditional Formatting, select New Rule, Use a formula etc then paste in this....

=filteron(A1)

Select the format of your choice, I use a Red fill because it really standards out, click OK
Apply your filter(s) and hopefully the Header will change colour.

Good luck

Ak

 

[Jungle Fever]

Thanks I will try it this weekend. THanks