Macro to populate text when condition is met
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?
|