Help with dates as reminders
 

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

Help with dates as reminders
 

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(B1A1;TRUE;FALSE)

where B1 is the payment due cell and A1 the NOW cell.

"C.me" wrote:

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

Help with dates as reminders
 

You don't need IF.
=B1A1 will do.
--
David Biddulph

"Hendrik" wrote in message
...
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(B1A1;TRUE;FALSE)

where B1 is the payment due cell and A1 the NOW cell.

"C.me" wrote:

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

Help with dates as reminders
 

On Jan 25, 9:01 am, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
You don't need IF.
=B1A1 will do.
--
David Biddulph

"Hendrik" wrote in message

...

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(B1A1;TRUE;FALSE)

where B1 is the payment due cell and A1 the NOW cell.

"C.me" wrote:

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

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