Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check to see if Autofilter is Engaged
In Excel 2003....
I have been asked to look into changing the color of the arrow on an autofilter tab for a filtered cell from blue to some other color so it can be more easily distinguished from the black tabs which are not filtered. I know the actual color of the arrow cannot be changed. However, is there some formula (like ISERROR() only ISFILTERED()) which can be used to see if an autofilter is engaged on a particular cell? I have also tried using VBA and conditional formats to change the color of the Header cell when a filter was being used, but this is a shared workbook, and when I was testing it out, I received an error(However, it did work when the workbook was not shared). Any help or suggestions would be much appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional format when autofilter engaged | Excel Discussion (Misc queries) | |||
2007 Autofilter worse than 2003 Autofilter | Excel Discussion (Misc queries) | |||
Increase size of a Forms Check Box (click on to enter check mark) | Excel Discussion (Misc queries) | |||
Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) |