Hello!
I have a list with different work, which are supposed to start on different dates. I would like to get notification through a pop-up poster/window with every work, starting in 10 days.
sample of the list attached. Thanks for any reply!
regards
Oystein
you could do this through conditional formatting...
1. highlight the range you want to apply the conditional formatting to
2. on the home tabe, styles, select CF
3. select new rule, select use formula
4. enter =$E6<=TODAY()+10 format fill as required
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you for answer.
But what I really wanted to get like a pop up window, or even more clearly notification on every sheet as I open the workbook. So when I open the workbbok, there is a notification independently of which sheet I am in. Thanks for reply!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks