I have a worksheet with color coded cells and numerical data in each cell.
I'd like to tally the contents of the various colors. Any suggestions?
I have a worksheet with color coded cells and numerical data in each cell.
I'd like to tally the contents of the various colors. Any suggestions?
karls
Excel default functions cannot count or sum by color format.
See Chip Pearson's site for VBA code.
http://www.cpearson.com/excel/colors.htm
If cells are shaded due to Conditional Formatting you could possibly sum by
those conditions.
Gord Dibben Excel MVP
On Tue, 17 May 2005 10:15:00 -0700, "karls" <[email protected]>
wrote:
>I have a worksheet with color coded cells and numerical data in each cell.
>I'd like to tally the contents of the various colors. Any suggestions?
You would need code for that
http://www.cpearson.com/excel/colors.htm
Regards,
Peo Sjoblom
"karls" wrote:
> I have a worksheet with color coded cells and numerical data in each cell.
> I'd like to tally the contents of the various colors. Any suggestions?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks