color blind customising

[Gerry_gerry]

I work with someone who is marginally color-blind, and cannot distinguish
between dark-blue and black. As we are constantly using the auto-filter it
is very frustrating for him not to be able to tell which column has a filter
on or off.

Is there any way of changing the color of the little blue triangle (when
filter on) to say a red triangle.

Any help much appreciated

PS We're using excel 2003

 

[Paul B]

Gerry, want change the triangle color but will change the cell to the color
you want where the auto filter is on

http://blog.livedoor.jp/andrewe/

look for Filter Highlight

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Debra Dalgleish]

You can't change the triangle colour, but there's a sample file here
that uses programming to change the heading cell colour:

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

Under Filter, look for 'Colour Filter Headings'

 

[Gerry_gerry]

This is exactly what I was looking for. Thank you very much.

Is there any way I could get this macro to apply globally to any sheet
opened something like putting it in personal.xls?

 

[Debra Dalgleish]

The event code has to go on the sheet with the AutoFilter. It runs the
code when the sheet calculates.