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.

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.