The active AutoFilter changes property cells (color)?

[Vasiliy]

Hello everybody!
Please, help me with Excel.
There is the autofilter (AF) be established on the sheet in 100
columns.
It is possible to make on VBA that at use AF a cell in which the
condition has been entered was allocated by color, for example yellow?
In program Excel color of a triangle inside the button (black on dark
blue) varies.
At high sanctions of the screen (1400x1050) this change of color is not
visible almost.
Help!
Or inform what is it to make not probably.
Excuse for bad English.
Thanks all who will respond.

 

[Debra Dalgleish]

You can colour the headings with programming. There's a sample file here:

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

Under Filters, look for 'Colour Filter Headings'

 

[Vasiliy]

Thank you very very much.
So it is much easier to work.
Yours faithfully Vasiliy Kurgalin