| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofilter list arrow colors
In Excel 2003, The triangle in the drop down list button for any field that
is being used to filter a list is blue. I have a hard time distinguishing the color. Is there any way to change the color in the triangle? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autofilter list arrow colors
There's no way to change the drop down arrow's colour.
You could use programming to change the colour of the heading cell when a column is filtered. There are sample files he http://www.contextures.com/excelfiles.html Under Filters, look for 'FL0022 - FilterClick Colour' or 'FL0014 - Colour Filter Headings' Loris wrote: In Excel 2003, The triangle in the drop down list button for any field that is being used to filter a list is blue. I have a hard time distinguishing the color. Is there any way to change the color in the triangle? -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autofilter list arrow colors
Hi,
In 2007 you will not have that problem because the filters display a filter icon on them whenever a filter is applied. They also display a sort icon on the filter if the field has been sorted. Cheers, Shane Devenshire "Loris" wrote: In Excel 2003, The triangle in the drop down list button for any field that is being used to filter a list is blue. I have a hard time distinguishing the color. Is there any way to change the color in the triangle? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autofilter list arrow colors
This is the best thing I've found on the internet in a long time! Thank you
Debra - this will make my life a lot easier! "Debra Dalgleish" wrote: There's no way to change the drop down arrow's colour. You could use programming to change the colour of the heading cell when a column is filtered. There are sample files he http://www.contextures.com/excelfiles.html Under Filters, look for 'FL0022 - FilterClick Colour' or 'FL0014 - Colour Filter Headings' Loris wrote: In Excel 2003, The triangle in the drop down list button for any field that is being used to filter a list is blue. I have a hard time distinguishing the color. Is there any way to change the color in the triangle? -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autofilter list arrow colors
You're welcome! Glad to hear that you like it.
Annie1904 wrote: This is the best thing I've found on the internet in a long time! Thank you Debra - this will make my life a lot easier! "Debra Dalgleish" wrote: There's no way to change the drop down arrow's colour. You could use programming to change the colour of the heading cell when a column is filtered. There are sample files he http://www.contextures.com/excelfiles.html Under Filters, look for 'FL0022 - FilterClick Colour' or 'FL0014 - Colour Filter Headings' Loris wrote: In Excel 2003, The triangle in the drop down list button for any field that is being used to filter a list is blue. I have a hard time distinguishing the color. Is there any way to change the color in the triangle? -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Format Arrow Colors | Excel Discussion (Misc queries) | |||
| can do I change autofilter arrow colours | Excel Discussion (Misc queries) | |||
| changing filter arrow colors | Excel Discussion (Misc queries) | |||
| Arrow color on Autofilter | Excel Worksheet Functions | |||
| Autofilter selected arrow color | Excel Worksheet Functions | |||
Linear Mode
