sum by conditional formatted color

[Guest]

I'm using Pearson's sumbycfcolorindex UDF, however I have a problem. (See
here for info on this UDF: http://www.cpearson.com/excel/CFColors.htm)

As I understand it from his instructions, if the conditional formatting is
applied with a formula that uses relative references, an incorrect sum will
result. The problem is, the range over which I have applied the conditional
formatting formula with relative references is AK18:AV29.

I would rather not have to change each individual cell's conditional format
formula from relative to absolute references. Is there a way to do this en
masse?

Thanks,

Dave

 

[Pete_UK]

Hi Dave,

maybe apply the conditional format formulae in helper columns to
return "Red", "Green" etc. and then use countif on these.

Hope this helps.

Pete

 

[T. Valko]

If you're using cf to color the cells you should be able to use that same
logic to sum the cells.

IMHO, calculations based on formats is a bad idea.

Biff