View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default 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?