SumByColor(Rng)

  • Thread starter Thread starter JimMay
  • Start date Start date
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
 
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...
 
Back
Top