ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I change the color of the drop down arrow on a filter? (https://www.excelbanter.com/excel-discussion-misc-queries/39248-how-can-i-change-color-drop-down-arrow-filter.html)

Stique

How can I change the color of the drop down arrow on a filter?
 
The color of the arrow - black - is hard to distinquish from the activated
color - dark blue. I'm looking to change the color to a more distinctive
style.

FSt1

hi,
A control must have a property that can be changed before you can change it.
look in the property box of the drop down contorl. back color, fore color,
border color is all i see that can be changed.

Regards
FSt1

"Stique" wrote:

The color of the arrow - black - is hard to distinquish from the activated
color - dark blue. I'm looking to change the color to a more distinctive
style.


dominicb


Good morning FSt1

Nope. Can't be done I'm afraid, though this is a constant gripe with
excel users.

However, would a compromise do? Debra Dalgleish has an article which
discusses automatically changing the colours of a row heading when a
filter is invoked.

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

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=393885



All times are GMT +1. The time now is 05:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com