Macro Help required

[kamalthakur]

Hi Everybody,

Could someone please help me out with the below request.

I have an excal sheet which has three columns
Actual Date
First Reminder Date
Second Reminder Date

the help i need is Everyday when i open that workbook the first reminder day should get highlighted one day in advance

For example today's date is 05th June 2008 and the first reminder date is 08th June 2008 so if i open the file on 07th June 2008 the First reminder date should get highlighted same as the case with the second reminder date and the second reminder date should get highlighted two days in advance.

Could someone please help me out in this.

I have attached a help excel file with this.

[Naras]

Kamal,

See the attached sheet.
I have inserted some conditions here.
To see them go to format->Conditional Formating , where you can chage the color,font and many such formats.

cheers
Naras

[royUK]

kamalthakur

Please read the Forum rules & use Titles that are descriptive of your question

[kamalthakur]

This is what i am not looking for.

Everyday when i open my workbook the dates should get highlighted based on current date

[Naras]

Everyday when you open the sheet, Excel will highlight the appropriate dates. The sheet attached will automatically do that. you don;t need any macros for this. If you still have some problem, please don;t hesitate to reply back.

[royUK]

I've asked to read the rules & use the correct style of Thread Title. I'm locking this post until you do so & email myself or any Moderator that you have done so & will comply with them.