G
glenrayel
I have a finance company which works on a 30 day pay period. Th
spreadsheet I created for this is getting very large and it is becomin
difficult to scan for accounts that need attention. The spreadsheet i
set up on the date the client first takes money and at 30 days into th
plan there is some action that needs to be taken by us. Because o
this we have to look through the entire spreadsheet date by date, eac
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 resolv
but it becomes rather hectic.
What I would like to know is if there is a way to have the cell, whic
contains the date 30 days down the road, flash or do something t
signal this event is about to happen. In other words, say on the 28t
day, is there a way for it to let me know that the clients 30 days ar
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 kno
that date is about to occur, how do I type it in and into what cell d
I enter the instruction? As you can tell, I am new to Excel and I a
not real familiar with the terminology, so please keep it as simple a
possible for this simple mind.
Oh and by the way - I keep seeing these comments about Excel VB
problems - what in the world is a VBA?
Thank you in advance - I hope someone can help me!
glenraye
spreadsheet I created for this is getting very large and it is becomin
difficult to scan for accounts that need attention. The spreadsheet i
set up on the date the client first takes money and at 30 days into th
plan there is some action that needs to be taken by us. Because o
this we have to look through the entire spreadsheet date by date, eac
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 resolv
but it becomes rather hectic.
What I would like to know is if there is a way to have the cell, whic
contains the date 30 days down the road, flash or do something t
signal this event is about to happen. In other words, say on the 28t
day, is there a way for it to let me know that the clients 30 days ar
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 kno
that date is about to occur, how do I type it in and into what cell d
I enter the instruction? As you can tell, I am new to Excel and I a
not real familiar with the terminology, so please keep it as simple a
possible for this simple mind.
Oh and by the way - I keep seeing these comments about Excel VB
problems - what in the world is a VBA?
Thank you in advance - I hope someone can help me!
glenraye