Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting cells in a column based on thier color
See
http://www.cpearson.com/excel/colors.htm -- Kind Regards, Niek Otten Microsoft MVP - Excel "rjkulesa" wrote in message ... Hello all: I have 100 random numbers in column A. The majority of the cells have the normal transparent background. Some of the cells are shaded blue, red, and green. I would like to write a formula (or 3) that sums all the blues, then returns the sums of all the reds, and then sums all the greens. Cells that have the transparent backgrounds are ignored. Any ideas? Thanks. rjkulesa |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting the number of rows based on the color | Excel Discussion (Misc queries) | |||
Format of Cells Changing on thier own | Excel Discussion (Misc queries) | |||
Format of cells Changing on thier own | Excel Worksheet Functions | |||
Summing cells within a column based on cell fill color | New Users to Excel | |||
Counting items in one column based on criteria in another column | Excel Worksheet Functions |