Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
color of filter arrows
When I apply a filter to an Excel spreadsheet, the arrows
at the top of each column are black. When I apply the filter to a column, the arrow turns blue. I am having difficulty seeing the color difference and was wondering if there is a way to change the color for the arrows so that when the filter is applied it turns a brighter color (perhaps red?)... If anyone knows how to do this, I would appreciate hearing from you. -- Tanguy |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
color of filter arrows
You can't change the colour of the filter arrow.
However, if you can use programming, you can colour the heading cell of the filtered column. There's a sample he http://www.contextures.com/excelfiles.html Under Filters, look for 'Colour Filter Headings' Tanguy Huysmans wrote: When I apply a filter to an Excel spreadsheet, the arrows at the top of each column are black. When I apply the filter to a column, the arrow turns blue. I am having difficulty seeing the color difference and was wondering if there is a way to change the color for the arrows so that when the filter is applied it turns a brighter color (perhaps red?)... If anyone knows how to do this, I would appreciate hearing from you. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the colour of the 'filter arrows' | Excel Worksheet Functions | |||
Change the color of Filter Arrows in Excel to BRIGHT RED | Excel Discussion (Misc queries) | |||
filter arrows showing when copy and paste to powerpoint | Excel Worksheet Functions | |||
DATA FILTER ARROWS DISPLAY WHILE INACTIVE | Excel Worksheet Functions | |||
Excel List range, filter arrows disappeared | Excel Discussion (Misc queries) |