Prev: Flag 'Filter on' for the user
Next: Place numbers in ascending order
From: Ross in Oz on 5 Feb 2010 06:42


"SMT" wrote:

>
>
> "BK" wrote:
>
> > how can i change the XL2003 autofilter's arrow color from blue (when active)
> > to red or another color? the current dark blue is hard to distinguish from
> > the black (inactive) color making it difficult to visually distinguish when a
> > filter is active.
> >
> > thanks. BK
This may help but it is limited as it advises if any filtered columns on a
worksheet are in action
Apply the formula to a cell outside the any of your filtered columns. A5:A45
is the sample so change to suit your range.
=IF(COUNTA(A5:A45)=SUBTOTAL(3,A5:A45),"NO","YES")
You can Conditional Format the cell to turn RED for "YES" and GREEN FOR "NO"

You can also get fancy to highlight the Excel filter in action advice blue
arrow (hard to see)
Use a cell next the YES/NO cell and give it a heading "LOOK FOR"
Format the cell with formula to Wingdings 3 with blue color font format to
produce the same arrow
=IF(COUNTA(A5:A45)=SUBTOTAL(3,A5:A45),"","q")
Have fun!

 | 
Pages: 1
Prev: Flag 'Filter on' for the user
Next: Place numbers in ascending order