Filter pull down icon color

[moonhkt]

Hi Reader
When change to Using LCD monitor, the pull down filter icon blue color
as same as black color in LCD monitor. Is it possible to check pull
down color to other color value ?


moonhkt

 

[Debra Dalgleish]

There's no way to change the drop down arrow's colour.

You could use programming to change the colour of the heading cell if a
column is filtered. There are sample files here:

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

Under Filters, look for 'FL0022 - FilterClick Colour' or 'FL0014 -
Colour Filter Headings'

 

[Dave Peterson]

I bet your data has empty rows in it. And I bet that you let excel guess at the
range that should be filtered.

If you're doing it manually, select the entire range to filter first, then apply
the data|Filter|autofilter.

If you're doing this in code, make sure the entire range is filtered.

 

[Gord Dibben]

Dave

I think OP does not want the Autofilter enabled.

Somehow the Import is generating the unwanted Autofilter.

My first thought was OP is importing into a List or Table but states
unchecking Data>Autofilter removes the dropdowns so would not appear to be
that.

Maybe the worksheet OP is importing to is not the Excel default?


Gord

 

[Dave Peterson]

Could be.

I read that "Now I get autofilters at the top of each column, and it won't load
all the data." was a complaint that the autofilters weren't "loading" all the
data.

====
Maybe showing all the data will avoid the problem that autofilter and using
..cells(...,...).end(xlup) may cause finding the last used row.