| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto filter based on color
Is MS Excel Auto Filter able to filter based on the color?
To be specific, I have a spreadsheet marked different colors in rows, and I would like to filter based on the color codes (rows) to sort the specific info I need. As far as my investigation, MS Excel 2002 don't seem to provide such function. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
auto filter based on color
Color filtering was introduced into xl2007 . To filter using color in older
versions requires custom code, it is was not a standard function of the autofilter. -- Regards, Nigel "Alan Ku" <Alan wrote in message ... Is MS Excel Auto Filter able to filter based on the color? To be specific, I have a spreadsheet marked different colors in rows, and I would like to filter based on the color codes (rows) to sort the specific info I need. As far as my investigation, MS Excel 2002 don't seem to provide such function. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing arrow color on the auto filter | Excel Discussion (Misc queries) | |||
| How do I change the color of the auto filter on/off icon? | Excel Discussion (Misc queries) | |||
| Auto filter by background color. | New Users to Excel | |||
| How do I filter based on color in Excel? | Excel Worksheet Functions | |||
| Problem - Filter based on color? | Excel Programming | |||
Linear Mode
