Help with dates as reminders

  • Thread starter Thread starter C.me
  • Start date Start date
C

C.me

I'm working for a car dealer that has payments due from Buy Here - Pay Here
and I'm wanting to make a spreadsheet with all the people and when payments
are due- Question is how do I set it up that the day it comes due the day
would change a color and if so make alarm go off??????? Can do basic exel
but this new one is alot more than I can handle if someone would please help
me.....
Thanks
 
If you have today's date in a cell (=NOW), you can make a condtional format
in the cell with the payment due date;

=IF(B1>A1;TRUE;FALSE)

where B1 is the payment due cell and A1 the NOW cell.
 
You don't need IF.
=B1>A1 will do.
Click to expand...

As regards making an alarm go off, this might be a little difficult to
do. There are options for you however.

First of all you can set up Conditional Formatting in your cells so
that they highlight when your criteria are met. For a more indepth
explanatin of conditional formatting visit this link:-

http://www.cpearson.com/excel/cformatting.htm

For the alarm you could set up some VBA code which runs in your sheet
when it is opened and checks the cells in your worksheet based on your
criteria. The code could then indicate which rows in your sheet are
the ones which need to be attended to today. Given you are new to
Excel this could be quite advanced, but Im sure I could help if it's
an urgent requirement. For now conditional formatting will highlight
cells which need attention, it'll just mean you have to manually
scroll through your data to see.

HTH.

Matt Richardson
http://teachr.blogspot.com
 
Back
Top