This is a second post as MS seemed to stop during posting.

Set Condition 1 to Formula is =AND(A1<=TODAY()-10,Z1="")

By setting it to greater than zero you will not show anything until text is
entered in the cell. Also, make sure that you format the cell background as
there is nothing in the cell to format the text.

Peter Atherton

"Hanah" wrote:

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.



"Bob Phillips" a scris:

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?