Conditional Formating & Pop Up Box.

[hdevadiga]

Dear Users,

Hi, myself Harindra, i have a problem while doing this file.

When you open a "Customer Details.xls" file, in Sheet1 you will see the heading like this:

Reminder 1 Agreement Days Due Date
07/25/08 3 07/28/08


Now i want is this. The date which is mentioned below "Due Date" (07/28/08), should show in "red" color on particular that date & i should get a "pop up message box" saying "today is a due date".

Waiting for reply,
Harindra G. Devadiga

[Kenneth Hobson]

What is logic for doing it? Just format as red. Not sure what would trigger a popup or what that means.

You need some kind of logic like:
1. When Due Date is today o earlier when I first open the workbook, then show a MsgBox and color the text red. Conditional formula will take care of formatting .