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