You can highlight the cell (in many ways) using conditional formatting. Look at the example of your spreadsheet, I have made the 3 MTHS DATE cell change colour when today or later is reached.
To customise it to your liking, click on the Start tab then under Styles click on Conditional formatting.
Click on Manage Rules then click on the rule and then on Edit Rule.
Here you can see the formula enterd (for future reference) and next to the Preview is a button - Format. Click on that to change the Style of how you want to cell to look when today or later is reached.
I also hidden the dates for unused cells to tidy the sheet up a little so if you enter a date in the TOMS RXC column then the future date will appear.
Let me know if I am not making any sense

You can use conditional formatting to turn the dates in Col G red when they are >= the date calculated.
Conditional Formatting Formula for Col G: =TODAY()-$G4>=0CondFmt.JPG
Note: I changed your date for illustration (highlighted in yellow). You can use the format painter to copy the format down the column or use the Rule Manager to change the range it applies to. HTH

Can you be a bit more specific. For Excel to assist you would need to open the workbook every day so that the workbook would compare the due date and the current date. This could be done by using Excel's Auto Open routines. However this still requires someone to open Excel. What I mean is if someone is away for several days and does not Open Excel you have no protection.

However, if you are using Outlook putting a reminder in Outlook Calendar with a one click "Send out E-Mail" could all be done and skip the Use of Excel. Outlook supports Macro's.

You would put the code you create to email the message where the messagebox is. To send an email look at the code here: http://www.rondebruin.nl/win/section1.htm. You don't ahve enough information for providing more details about the email message.

The question for us when when help write the code is not where you put the email addresses, but where will the code find them. Is it just 1 email address, will there be a different email address (or address) for each date? What else will be in the email, etc, etc. What I provided was sample code to email and a method for the workbook to get the appropriate "trigger". If you need further help from us, walk us through what you want to happen when that trigger is pulled (and we need details)....

I only want 1 email sent for each date line in column G, I have re posted the spread sheet again Version 13.... made a few mistakes trying to use the code you sent me

If you look in Column G you will see there is 4 dates, one is highlighted in yellow, which means the date has been reach. (email required to be sent on that date)
You will also notice 3 other dates below, which are in the future, when the dates match the computer date (present date) the date will change yellow and should send off an email.

As you can appreciate there will be a lot of email for the amount of lines in column G, I already know this. I only want 1 email sent to both parties for each line in column G

Maybe use the Task Scheduler, that invokes a batch file, that invokes the Excel spreadsheet with an Auto Open macro, which creates a file depending on the date criteria, which the batch file will check for its existence. Haven't figured out how to get an email generated and sent.

You can try this, it uses sendmail. The subject of the email will be "90 days has elapsed, property needs to be Disposed of" and the file will be attached. That is about the limit with sendmail. (to and subject, with attached workbook, sendmail has no "body" to use)

More options could be done if you had EXCEL vba send an email using outlook. This code sends it to the 2 emails, with the subject line: "90 days has elapsed, property needs to be Disposed of" and the Body lists the name, file num, and description (other options are available) of the property.

Thank you

Steve,

Firstly I never considered both options which you clearly thought of.

Thank you for taking the time and having the patience to help me out, due to myself having limited or no knowledge.

I will return to read how to insert or place the code into the worksheet, surely I cant stuff that up, but then again. look at the version titles for the amount of time I have had to change it. (laughing).... all good , they say that how you learn by making mistakes and being able to laugh at yourself.

Either way to all those that have spent time helping me.. I extend my appreciation to you All.