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

SumByColor(Rng)
 

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

In article <jWa9g.28119$fG3.10364@dukeread09, "JimMay"
wrote:

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

SumByColor(Rng)
 

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

"JE McGimpsey" wrote in message
:

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

In article <jWa9g.28119$fG3.10364@dukeread09, "JimMay"
wrote:


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