Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tanguy Huysmans
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change the colour of the 'filter arrows' sandro Excel Worksheet Functions 5 May 23rd 09 09:44 AM
Change the color of Filter Arrows in Excel to BRIGHT RED AlwaysThinking Excel Discussion (Misc queries) 6 April 21st 08 10:22 PM
filter arrows showing when copy and paste to powerpoint confused Excel Worksheet Functions 0 November 11th 05 12:25 PM
DATA FILTER ARROWS DISPLAY WHILE INACTIVE lassie Excel Worksheet Functions 0 August 3rd 05 02:41 PM
Excel List range, filter arrows disappeared andrew Excel Discussion (Misc queries) 3 April 1st 05 11:30 PM


All times are GMT +1. The time now is 01:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"