| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ColorIndex count function
I thought I could alter any number of function examples that count the cells in a range for either the Font color or the Cell.Interior.ColorIndex or both.
I want to count ANY ColorIndex in a range like C4:C14. Where the call for the function would be something like =ColorCnt(C4:C14). So any cell in that range with any of the 56 color index numbers colors would get counted. (A separate function for the font of any color might be useful also) Thanks, Howard |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count the Colorindex of a cell with a conditional format | Excel Programming | |||
| Colorindex | Excel Programming | |||
| Can't use COUNT function to count.csv rows? | Excel Programming | |||
| To reset the Interior.ColorIndex function | Excel Programming | |||
| Public Function to Return ColorIndex | Excel Discussion (Misc queries) | |||
Threaded Mode
