Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort or sub-total by Fill color or font color
I grouped my worksheet by highlighting cells with different Fill Color or
Font color. Will there be a way to sort the data with fill color or font color. Further, can I subtotal the data with fill color or font color? Appreciate your response in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort or sub-total by Fill color or font color
Excel will not sort, sum, count and other functions based on BG color or Font
color. You need to download some User Defined Functions from a site such as Boob Phillips' colorcounter page. http://www.xldynamic.com/source/xld.ColourCounter.html Gord Dibben MS Excel MVP On Thu, 27 Apr 2006 12:17:02 -0700, Excel_seek_help wrote: I grouped my worksheet by highlighting cells with different Fill Color or Font color. Will there be a way to sort the data with fill color or font color. Further, can I subtotal the data with fill color or font color? Appreciate your response in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort by Fill Color | Excel Discussion (Misc queries) | |||
color fill cells based on IF function or formula | Excel Worksheet Functions | |||
Fill Color Red | Excel Discussion (Misc queries) | |||
I have cells with diffent color fonts and need to total based on . | Excel Discussion (Misc queries) | |||
Excel 2003 will not display color fonts or color fill cells | Excel Worksheet Functions |