i am trying to make a formula that once an invoice gets so old that i am
alerted by the changing of color in the cell. the problem is, is that it has
been so long since doing formulas that i cant remember one to accomplish
this. any help would be much appreciated.

thanks ahead of time,
Amber

I presume you have a list of invoices generated, and that for each
invoice you would have data like the invoice number, company name and
address, amount owing, date issued, date paid etc.

If so, you could compare the date issued with today's date in a
conditional format, and if, say, the date issued is more than 30 days
and it is still unpaid then make the background colour change to red.
As you can have up to 3 conditional formats, then you could have a
different colour for 60 days or more, and for 90 days or more.

However, you have not told us anything about your data - which cell(s)
would you like this effect to apply to, and what columns are used for
date issued, date paid etc?

If you can give some exact details, then we can give you an exact
formula to use.

Pete

smurf wrote:
> i am trying to make a formula that once an invoice gets so old that i am
> alerted by the changing of color in the cell. the problem is, is that it has
> been so long since doing formulas that i cant remember one to accomplish
> this. any help would be much appreciated.
>
> thanks ahead of time,
> Amber

my invoice numbers and dates are in seperate colums along with customer
number , order numbers, delivery numbers and so on.

"Pete_UK" wrote:

> I presume you have a list of invoices generated, and that for each
> invoice you would have data like the invoice number, company name and
> address, amount owing, date issued, date paid etc.
>
> If so, you could compare the date issued with today's date in a
> conditional format, and if, say, the date issued is more than 30 days
> and it is still unpaid then make the background colour change to red.
> As you can have up to 3 conditional formats, then you could have a
> different colour for 60 days or more, and for 90 days or more.
>
> However, you have not told us anything about your data - which cell(s)
> would you like this effect to apply to, and what columns are used for
> date issued, date paid etc?
>
> If you can give some exact details, then we can give you an exact
> formula to use.
>
> Pete
>
> smurf wrote:
> > i am trying to make a formula that once an invoice gets so old that i am
> > alerted by the changing of color in the cell. the problem is, is that it has
> > been so long since doing formulas that i cant remember one to accomplish
> > this. any help would be much appreciated.
> >
> > thanks ahead of time,
> > Amber
>
>