Hi,
see

http://www.cpearson.com/excel/colors.aspx

and

http://www.xldynamic.com/source/xld.ColourCounter.html

if this helps please click yes thanks


"Atomic" wrote:

I need some help creating a macro which will allow me to add the total sum of
a cell when I change colour.

i.e

Cell D3,H3, K3,K3 is coloured between C3 to R3, I want S3 to have the the
sum of the coloured cells, which is 4? Is that possible?

Thank you.