Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can you change the colour of an Excel autofilter arrow??
I can not easily differentiate between the black unfiltered columns and the
blue filtered one/s. Is it possible to change the arrow on the filtered column to a different colour? Thanks in advance |
#2
|
|||
|
|||
Paula
I'm afraid not -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Paula" wrote in message ... I can not easily differentiate between the black unfiltered columns and the blue filtered one/s. Is it possible to change the arrow on the filtered column to a different colour? Thanks in advance |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
Can you change the colour of an Excel autofilter arrow??
Though of course you could use a worksheet event macro? Private Sub Worksheet_Change(ByVal Target As Range) Dim af As AutoFilter Dim fFilter As Filter Dim iFilterCount As Integer If ActiveSheet.AutoFilterMode Then Set af = ActiveSheet.AutoFilter iFilterCount = 1 For Each fFilter In af.Filters If fFilter.On Then af.Range.Cells(1, iFilterCount).Interior.ColorIndex = 6 Else af.Range.Cells(1, iFilterCount).Interior.ColorIndex = xlNone End If iFilterCount = iFilterCount + 1 Next fFilter Else Rows(1).EntireRow.Interior.ColorIndex = xlNone End If End Sub -- roundabout ------------------------------------------------------------------------ Posted via http://www.mcse.ms ------------------------------------------------------------------------ View this thread: http://www.mcse.ms/message1745970.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
Is it possible to change the blue colour of an activated Auto Filter button? | Excel Discussion (Misc queries) | |||
how do I change the text case of imported data in excel? | Excel Discussion (Misc queries) | |||
Macro button colour change??? | Excel Worksheet Functions |