color blind customising

  • Thread starter Thread starter Gerry_gerry
  • Start date Start date
G

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
 
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
 
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?
 
The event code has to go on the sheet with the AutoFilter. It runs the
code when the sheet calculates.
 
Back
Top