Hi, and many thanks in advance!


Say I have a range "range("A1").currentregion named Rng


say Rng is filtered


is it posible to change the formatting of Rng'headers if the filter i
ON

eg: Rng.AutoFilter Field:=3, Criteria1:="Europe"

I mean, if A1=Country B1=Population C1=Continent

If I chose in C1 the filter criteria Europe, then C1 must be Yellow
then if i say in A1=Spain A1 must be yellow


then if i take out the filters A1:C1 must be without colour.
I mean:
Rng.AutoFilter Field:=3
Rng.AutoFilter Field:=2
Rng.AutoFilter Field:=1

I am trying to do this because the blue colour showed in the dropdow
control when pressed is not enought.
so I would like to make it ckear if a filter is benn Pressed!

Any idea????????

--
0000_AAAA_000
-----------------------------------------------------------------------
0000_AAAA_0000's Profile: http://www.excelforum.com/member.php...fo&userid=1248
View this thread: http://www.excelforum.com/showthread.php?threadid=26650