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
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.