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.