SumByColor(Rng)

J

JimMay

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
 
J

JimMay

Hummm...(??) Thanks JE -- I'll pursue that suggestion.
Jim May

Why not just use the same conditional in your formula that is used in
the CF?

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
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA defined function problem sumbycolor 2
SumByColor Macro... 6
Linking cells, with values and formats: VBA 0
Border formatting row of cells 22
Chip Pearson UDF returns #VALUE! error please help, just cannotfigure out why? 4
Summing Cells with a BLUE font (or any other color) 2
Total newbie question involving pasting someone else's Macro 2
Please Help 11

Top