Hello!
i have a column which shows when a contract expires. three days before the expiry i need to send an email. Hence, i have used conditional formatting to highlight cells whereby if the expiry date is less than 3 days from today, it is highlighted in red. Now i would also like to have a pop-up message which reminds me to check for these cells highlighted in red?
how do i do so?
please help.
Thanks in advance
Hi, welcome to the forum
1 purpose of CF IS to flag you when certain criteria are (or are not) met. If thats not working for you, why even bother to use it? Perhaps, instead, use a helper column to generate something, then, in your header, test for that, and make that change color - or give a message?
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
thanks for the tip
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks