| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function for summing or counting cells based on a specified fill color
Hi
I would like to create and run a function that Sums or counts cells based on a specified fill color, for e.g. say i have a green fill in Cell B1 and I have different fill colours in Range (A1:A10) I would like to know how many cells in (A1:A10) have the same green fill as in Cell B1 Thanks San |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help in counting and summing cells based on multiple conditions | Excel Worksheet Functions | |||
| Summing cells within a column based on cell fill color | New Users to Excel | |||
| change fill color of a range of cells based on color of a cell? | Excel Programming | |||
| color fill cells based on IF function or formula | Excel Worksheet Functions | |||
| Counting/summing cells based on background color | Excel Programming | |||
Threaded Mode
