anouncing that it is time for paiment
Use conditional formatting, with a formula of
=AND(start_date_cell<=TODAY()-10,payment_made_cell="")
--
__________________________________
HTH
Bob
"Hanah" wrote in message
...
I have clients that I am intruducing starting with a date. After exactly
10 days, I have to pay them some money. I would like to be notified by
changing colour of the their rows, and not changing back until I complete
the
cell of paiment, that is, of course, in the same row. Is it possible to do
this in Excel 2007?
|