Notify me when a date is with in 25 days of the current date

I need to create an alert to pop up when an Excel worksheet is first opened to look at cell C10 and notify me that the date is within 25 days of the current date. Then the user could acknowledge the alert and continue working on the worksheet.

Is this done via macros or how?

any help is greatly appreciated

Yes, the conditional formatting does work but I am looking for something more in your face upon opening the worksheet like an MSGBOX with a message telling the user the report is due within 25 days, any ideas on that? Thank you, I will use the conditional formatting in addition to a message box.

.
Paste this macro into the ThisWorkbook module :

Please Login or Register  to view this content.

Thank you That worked

You are welcome.