Excel - Change colour of autofilter arrows

[Bill4tektips]

Does anyone know if there is a way to change the colour of autofilter arrows from Blue to Red?

 

[kjv1611]

http://excel.tips.net/Pages/T002371_Changing_AutoFilter_DropDown_Arrow_Colors.html

--

"If to err is human, then I must be some kind of human!" -Me

 

[kjv1611]

For other options:

http://lmgtfy.com/?q=excel+2007+change+autofilter+colors

--

"If to err is human, then I must be some kind of human!" -Me

 

[Gavona]

I reckon that issue annoys loads of folk. I think that to resolve you need a macro in the workbook in question. One of these might do it for you but I never got around to actually trying them. Let us know what works for you.

http://www.ozgrid.com/forum/showthread.php?t=49112

http://help.lockergnome.com/office/change-colour-Excel-autofilter-arrow--ftopict629929.html

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

I also remember a function/macro to display the filter criteria above the filtered cells heading. Can't find my link to it though at the moment


Gavin

 

[Gavona]

To display the criteria:

http://robertmarkbramprogrammer.blogspot.com/2008/09/excel-displaying-autofilter-criteria.html

http://j-walk.com/ss/excel/usertips/tip044.htm

http://www.ozgrid.com/VBA/autofilter-criteria.htm

Gavin

 

[Bill4tektips]

Hi Guys, All your solutions are just to colour the first cell so I guess that to change the arrow colour must be down to Microsoft. Thanks anyway