anouncing that it is time for paiment

  • Thread starter Thread starter Hanah
  • Start date Start date
H

Hanah

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?
 
Use conditional formatting, with a formula of

=AND(start_date_cell<=TODAY()-10,payment_made_cell="")
 
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,Z1>0)

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



"Bob Phillips" a scris:
 
Hanah

Bobs formula is fine. Select the range you want to format, Format,
Conditional Format, set Condition 1 to 'Formula is' and paste the formula
=AND(A1<=TODAY()-10,Z1="")

Use the double quotes rather than zero, Change the Background Pattern to the
colour of your choice; it's no good choosing text because the cell is blank.
and it will work.

regards
Peter Atherton
 
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
 
Back
Top