I have an invoicing spreadsheet that shows the difference (in days) between
the invoice dates and the due dates for each invoice. Id like to create a
formula or macro that would populate the word €œOverdue€� in red/bold letters
when the invoice reaches day 30. It would be a bonus if there way a way to
animate this text (e.g., blinking background) . Any suggestions?

Hi,

This involves a bit of guesswork because you don't tell us how you know if
an invoice has been paid so:-

A1= Invoice date
B1 =today()-A1 This gives an increasing number of days
C1 = something to indicate the invoice paid

try this formula
=IF(AND(B130,C1=""),"Overdue","")

With regard to colour simply format the cell with the formula in as Red and
Bold. I'm afraid I don't do flashing cells because I find it irritating and
so I suspect would you if you had dozens of them flashing on a sheet. Someone
else may be prepared to help if you really want this.

Mike


"bnim" wrote:

I have an invoicing spreadsheet that shows the difference (in days) between
the invoice dates and the due dates for each invoice. Id like to create a
formula or macro that would populate the word €œOverdue€� in red/bold letters
when the invoice reaches day 30. It would be a bonus if there way a way to
animate this text (e.g., blinking background) . Any suggestions?

Hi

With days in A1, use this formula in B1:

=IF(A1=30,"Overdue","")

Then apply conditional formatting in B1 using: Formula is: =B1="Overdue" and
choose the desired formatting.

Regards,
Per

"bnim" skrev i meddelelsen
...
I have an invoicing spreadsheet that shows the difference (in days) between
the invoice dates and the due dates for each invoice. Id like to create
a
formula or macro that would populate the word €œOverdue€� in red/bold
letters
when the invoice reaches day 30. It would be a bonus if there way a way
to
animate this text (e.g., blinking background) . Any suggestions?

Blinking cells are possible but not recommended due to their annoyance
factor.

You are better off with just conditional formatting as Per points out.

If you reeaaaalllllyyyy want blinking text see Chip Pearson's site and be
prepared to do a little work with VBA.

http://www.cpearson.com/excel/BlinkingText.aspx

But if for other users, they will probably disable macros after the first
time they see that blinker.


Gord Dibben MS Excel MVP

On Sat, 4 Oct 2008 12:52:00 -0700, bnim
wrote:

I have an invoicing spreadsheet that shows the difference (in days) between
the invoice dates and the due dates for each invoice. I’d like to create a
formula or macro that would populate the word “Overdue” in red/bold letters
when the invoice reaches day 30. It would be a bonus if there way a way to
animate this text (e.g., blinking background) . Any suggestions?