Macro to populate text when condition is met

[bnim]

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?

 

[Mike H]

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(B1>30,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

 

[Per Jessen]

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

 

[Gord Dibben]

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