Take a look at
http://www.cpearson.com/excel/colors.htm

"GR" wrote in message
...
I have a row of numbers, some black and some blue. Is it possible to set up
a formula to look at the entire row and (i) return the sum of only the
black numbers and (ii) update the sum each time I change the color of a
number from blue to black? If so, I would appreciate guidance!
Thank you,
GR