Excel indicator for when a future date is reached!

I have a finance company which works on a 30 day pay period. The
spreadsheet I created for this is getting very large and it is becoming
difficult to scan for accounts that need attention. The spreadsheet is
set up on the date the client first takes money and at 30 days into the
plan there is some action that needs to be taken by us. Because of
this we have to look through the entire spreadsheet date by date, each
and every day to see if the client has reached the thirty day mark yet.
I have tried sorting by dates which seems to be the obvious resolve
but it becomes rather hectic.

What I would like to know is if there is a way to have the cell, which
contains the date 30 days down the road, flash or do something to
signal this event is about to happen. In other words, say on the 28th
day, is there a way for it to let me know that the clients 30 days are
up in two days or maybe 3 days ahead to get around weekend problems?

An example of what I currently have might look something like this:
A1 = 01/01/2004
A2 = A1+30
If there is a way to make cell A2 flash or do something to let me know
that date is about to occur, how do I type it in and into what cell do
I enter the instruction? As you can tell, I am new to Excel and I am
not real familiar with the terminology, so please keep it as simple as
possible for this simple mind.

Oh and by the way - I keep seeing these comments about Excel VBA
problems - what in the world is a VBA?

Thank you in advance - I hope someone can help me!

glenrayel


---
Message posted from http://www.ExcelForum.com/