![Send a message via MSN to NiTRO-[X]](http://www.excelforum.com/images/misc/im_msn.gif)
Expiry Date Indicator
Hi All,
For days I'm trying to create cells that indicates the start and the expiry date.
The Start Date and the End Date is located in Sheet1 while the formula reflects it on other Sheets.
Now the tricky part is: I need the indicated cells to be also available for data entries which stops me from entering any formula within cells.
Attached an end result sample in case my description is not clear.
Appreciate any ideas- Thank you
Last edited by NiTRO-[X]; 11-04-2011 at 03:45 AM. Reason: Resolved
Your problem is still not clear. Maybe you can try explaining again keeping in mind the attached file?
Sheet1 contains Start Date and End Date.
Sheet2, Sheet3 represents individual months in which cells representing days of each month.
Changing the Start Date and the End Date in Sheet1 reflects a color on Sheet2 and Sheet3.
The cells that indicates the Start Date and End on Sheet1 or Sheet2 needs to be blank for other manual data entries.
Last edited by NiTRO-[X]; 11-04-2011 at 03:28 AM.
see attatchment
result taken through conditional formating
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
Thank you its exactly what I was looking forOriginally Posted by Azam Ali
the other sheets could be used in the conditional formating through defining the name through formula tab
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
![NiTRO-[X] is offline](http://www.excelforum.com/images/statusicon/user-offline.png)
Reply With Quote
Bookmarks