Try =AND($A1<TODAY()-10,$Z10)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"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.
After I reveived help from this forum, I've tried to do the next things:
I have:
A1 Z1 - TO PAY
10/07/2008 0
15/07/2008 30
05/07/2008 50


Z1 - TO PAY cell ads the total amount the money that I have to pay in
other cells.

This is what I have done and it is not working.
Select A1:A3
Use conditional format - New rule - Use a formula to determine...
Format Set - Fill - Background colour - Read
Format values where this formula is true: =AND(A1<=TODAY()-10,Z10)

An then... nothing! I realise that I've made a mistake, but I don't know
where.