Q: Auto filter "selected" color
 

Using Excel 2000.

When I use the auto-filter and filter on a given column, the down arrow
shows as blue. Unfiltered is black. The colors look very similar.

Is there a way to change the filtered color?

Thanks!
-Mark

Q: Auto filter "selected" color
 

Debra Dalgeish posted this:

There's no way to change the colour of the filter arrows.

If you can use programming, there's a sample file here in which the
heading cell is coloured if a filter is applied to that field:

http://www.contextures.com/excelfiles.html

Under Filters, look for 'Colour Filter Headings'

Or, without programming, you can colour all the headings if any column
in the table has been filtered. For example:

Select all the headings
Choose FormatConditional Formatting
From the first dropdown, choose Formula Is
In the formula box, type:
=COUNTA($A:$A)<SUBTOTAL(3,$A:$A)
Click the Format button
On the Patterns tab, select a colour
Click OK, click OK

===========
From this thread:
http://groups.google.co.uk/group/mic... e564e49aeb0d9

or

http://snipurl.com/m8zc


sandro wrote:

Mark wrote:

Using Excel 2000.

When I use the auto-filter and filter on a given column, the down arrow
shows as blue. Unfiltered is black. The colors look very similar.

Is there a way to change the filtered color?

Thanks!
-Mark

--

Dave Peterson