date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Peeps

Many thanks in advance for any help/ advice that you can give me
I am trying to construct a simple database in Excel to track sales and payments made
Is there a way to use conditional formatting/or any other tool to highlight payment due not yet received by referecing it to the date on my computer

i.e the date on my computer is 6th June 2004, payment was due 30th May 2004, I would like the cell that has the due date to be highlighted

Best Regards
Yinka
 
Yinka

Format>Conditional Formatting>Cell Value is: less than =TODAY()

Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating interest due on late loan payments 1
Need help with calculation 2
Calulate interest for a loan as payments are received 2
Need Formula Help 6
How do I use Excel 2007 to determine late payment amounts 3
Making payments correspond to correct date 1
identifying the next working day after weekends and/or holidays 2
Using DATEDIF how do I add another month of each date fall on same 8

Back
Top