Formatting doesn't change the value in a cell. If you want to do that, use
a formula.
--
David Biddulph

"karen" wrote in message
...
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?