Help

[rajkumar.shukla]

Hi, I'm creating my task file in excel2007. In this file there is column for task description, Intimation date, start date, Set complition date, complition date and remarks. I want in intimation date cell, cell contain the date which is 5 days before the start date and the cell/text(date) blink untill the start date come. if the task completed in the defined complition date, "complete in time" is written automatically in remarks column, and if complition date is after the set complition date for the task "delay in complition" written automatically in remarks column.


anyone help me in this, so that I can able to manage my self and monitor my task.

 

[sgmpatnaik]

@Rajkumar.Shukla


Please note these words in your mind


1. Don't use the Such type of wards like Please Help me Urgently, help me, replay me fast etc.


2. Before you posting please read the 4 green sticky key rules in this forum


3. Always create correct headings as like, "SUMIF PROBLEM, SUMPRODECT PROBLEM, INDEX AND MATCH FORMULA DISPLAY ERROR ETC.


4. With Your correct heading our readers and NINJA'S will replay you correctly


5. Always try to give the more details to FORUM READERS / NINJA'S other wise try to posting the sample Work Book from the Link: - http://chandoo.org/forums/topic/posting-a-sample-workbook


Hope you understand


Thanks


SP

 

[sdsurzh]

Hi Raj,


Can you please download the below file and check.


http://www.2shared.com/file/sjvKJfsy/2_online.html


Thanks,

Suresh Kumar S

 

[bobhc]

Good day rajkumar.shukla


"Help" does not say much and many members would not bother to read the post. If you give more detail in the title box you will get more interest and therefore more help.