Hi Al,

See Bob Phillips ColourCounter page at:

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


and see Chip Pearson's Functions for Working With Cell Colors at:

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


---
Regards,
Norman



"Al" wrote in message
...
I want to exclude the values of cells that are shaded in a summation, e.g.
I
have SUM(A9: Z9) = 1000, but I do not want cells F9, M9 and Y9, so I
highlight them in, say, green, then manually amend the appropriate cell
calculation to deduct these values.

Can Excel account for highlighting in this way?