Prev: File Open: No Preview Available...why please?
Next: change XL2003 autofilter's arrow color
From: Ross in Oz on 5 Feb 2010 06:38
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!



"Max" wrote:

> Welcome ..
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> Downloads:19,000 Files:362 Subscribers:62
> xdemechanik
> ---
> "simon" <simon(a)discussions.microsoft.com> wrote in message
> news:A69E9F8A-0254-43AA-A5C1-F9451764A833(a)microsoft.com...
> >
> > Excellent, thank you. I've not used VBE before
>
>
>
 | 
Pages: 1
Prev: File Open: No Preview Available...why please?
Next: change XL2003 autofilter's arrow color