Question on Data Filter

dlhavens

New Member
Joined
Jun 24, 2008
Messages
1
I use data filter a lot and I was wondering if there was a way to change the color of the drop down arrow that has the filter on it. I have bad eyes and cannot hardly tell the difference between the blue and the black arrow. I use several filters in large spreadsheets so I have a hard time finding which columns I have a filter on. It would be nice if I could change the color from blue to yellow or orange so it would stand out better. I went into options on the color tab and it changed my worksheet but not the drop down arrows. I don't mind that the drop down arrows are black, it's just when there is a filter on the column it changes to blue and I would like a lighter color. Any help would be appreciated but I am thinking I am stuck with this.
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
hi there

Yes it is possible with vba. I've seen several codes on the net but i'm not sure if i can post links to other forums and I don't want to steel any ones code.

If you don't get help here, try google and you'll find the code you need.

regards,
shodan
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,255
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top