Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFilter Blue Arrow
I found an article he
http://www.contextures.com/excelfiles.html#Filter Article FL0014 - Colour Filter Headings -- Event code colours the filtered column headings, when an AutoFilter is applied. FilterColour.zip 9 kb 15-Apr-05 The contact infromation suggests that any questions should be posted in an MS forum...if I have misunderstood, sorry in advance. Question What is the purpose of the TODAY() formula in the FilterColour.download. The comment box explains that if the Auto Filter is switched oof, a calculation is performed, but I don't see what it's purpose is...if I delete it the cels still change to yellow. What might I be overlooking? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFilter Blue Arrow
The worksheet needs at least one formula because the colouring occurs
when there's a calculation on the worksheet. In the sample file, there are formulas in the last column of the table, so the TODAY formula can be removed. If you use the code in a different sheet, with no other formulas, add a formula like the TODAY example, to ensure that the colouring is applied when the filter changes. Dermot wrote: I found an article he http://www.contextures.com/excelfiles.html#Filter Article FL0014 - Colour Filter Headings -- Event code colours the filtered column headings, when an AutoFilter is applied. FilterColour.zip 9 kb 15-Apr-05 The contact infromation suggests that any questions should be posted in an MS forum...if I have misunderstood, sorry in advance. Question What is the purpose of the TODAY() formula in the FilterColour.download. The comment box explains that if the Auto Filter is switched oof, a calculation is performed, but I don't see what it's purpose is...if I delete it the cels still change to yellow. What might I be overlooking? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFilter Blue Arrow
Debra
Thanks for the reply and explanation. I can't believe I missed the whole column of formulae at the end. So in this case the TODAY() Formula isn't really neccessary. Thanks again "Debra Dalgleish" wrote: The worksheet needs at least one formula because the colouring occurs when there's a calculation on the worksheet. In the sample file, there are formulas in the last column of the table, so the TODAY formula can be removed. If you use the code in a different sheet, with no other formulas, add a formula like the TODAY example, to ensure that the colouring is applied when the filter changes. Dermot wrote: I found an article he http://www.contextures.com/excelfiles.html#Filter Article FL0014 - Colour Filter Headings -- Event code colours the filtered column headings, when an AutoFilter is applied. FilterColour.zip 9 kb 15-Apr-05 The contact infromation suggests that any questions should be posted in an MS forum...if I have misunderstood, sorry in advance. Question What is the purpose of the TODAY() formula in the FilterColour.download. The comment box explains that if the Auto Filter is switched oof, a calculation is performed, but I don't see what it's purpose is...if I delete it the cels still change to yellow. What might I be overlooking? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can you change the colour of the arrow from blue when filtering? | Excel Discussion (Misc queries) | |||
Blue Border and Down to the right arrow - BIZARRE DON'T KNOW | Excel Discussion (Misc queries) | |||
excel autofilter down-arrow bad contrast blue/black when in use | Excel Discussion (Misc queries) | |||
Excel VBA AUtofilter arrow (blue) on wrong column | Excel Programming | |||
Change rollover color on autofilter arrow from blue to red | Excel Worksheet Functions |