Hi,

Have a look here on how to sum coloured cells

http://www.xldynamic.com/source/xld....r.html#summing

Mike

"karen" wrote:

I have a list of invoices that have a colume of dates , then a colume of
amounts . I can conditional format it so that if its more than 30 days then
it changes the date to red. but is there a way of formating it so that it
adds up what is due?