Formula with no result

  • 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.
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,Z1>0)

An then... nothing! I realise that I've made a mistake, but I don't know
where.
 
Some thoughts for you to check over there
(I could get the CF working based on your posted formula)

1. Your selection step: > Select A1:A3
Was A1 active in the selection?
The CF formula is structured for the active cell A1
(if you had somehow selected the range from bottom up, ie A3:A1,
then A3 becomes the active cell, and the CF formula as-is won't work)

2. Are the dates in A1:A3 real dates recognized by Excel ?
If they're not, it won't work. I suspect this is the cause.

Try this to convert it all at one go to real dates. Select A1:A3, then click
Data > Text to columns. Click Next>Next. In step 3 of the wizard, under Col
data format, check "Date", choose: DMY from the droplist. Click Finish.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,000 Files:358 Subscribers:55
xdemechanik
 
This was a very good advice! Thank you! You gave me the idea of checking
the format of the date, and in my computer, TODAY is shown as M/D/Y. So, no
chance to work in Excel with D/M/Y. So, I just changed the format of the
date, and now is working. Thanks again!

"Max" a scris:
 
Back
Top