Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Count and Sum cells with certain format (e.g. color)
Im in the U.S. Navy and needed to count and sum a worksheet full of
peoples names whose cells are color coded to indicate where that person is. There are about four colors which i am trying to sum, is there a certain built in excel function that can do this, or will I have to resort to some VBA? If so could you provide some sample code....I am so stumped.. Thanks |
#2
|
|||
|
|||
Count and Sum cells with certain format (e.g. color)
If the cells are colored due to Conditional Formatting, use the conditions to
count or sum. If manually colored, you will need VBA. See Chip Pearson's site for code. http://www.cpearson.com/excel/colors.htm Gord Dibben Excel MVP On 7 Nov 2005 17:34:32 -0800, wrote: Im in the U.S. Navy and needed to count and sum a worksheet full of peoples names whose cells are color coded to indicate where that person is. There are about four colors which i am trying to sum, is there a certain built in excel function that can do this, or will I have to resort to some VBA? If so could you provide some sample code....I am so stumped.. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|