Thread: SumByColor(Rng)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JimMay JimMay is offline
external usenet poster
 
Posts: 28
Default 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