| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SumByColor(Rng)
I use the "normal" SumByColor(Rng,Colorindex) function written by Chip
Pearson. It works on cells colored when done so with the Color Fill Icon Or with Format, Cell Pattern, ColorSelect, OK. But the formula DOES NOT work if the cells (Range) is colored VIA Conditional Formatting. Does anyone have the code [and would share] to engage a SumRngWithCondFormating()? Much appreciate, in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SumByColor & #NAME? | Excel Worksheet Functions | |||
| sumbycolor formula | Excel Worksheet Functions | |||
| SumByColor Stopped Working | Excel Worksheet Functions | |||
| how to use sumbycolor fuction? | Excel Worksheet Functions | |||
| SumByColor Macro... | Excel Programming | |||
Threaded Mode
