Thanks David , Attached file
Date: Fri, 7 Dec 2012 09:15:36 +1000 Subject: Re: $$Excel-Macros$$ Re: Lease date alarm From: da...@grugeon.com.au To: excel-macros@googlegroups.com Hi Ahmed If you want more help you will have to give us more information. It is not helpful to just say "It did not work" You need to tell us just what you want to happen when the date arrives, and you need to tell us what happened when you made inserted the conditional formatting. It would be helpful to have a copy of the file with conditional formatting applied so we can see if (a) you have not applied the conditional formatting to the correct cells(b) you have not provided a suitable format to distinguish those cells where renewal is approaching(c) you do not have any leases where the renewal is approaching. Otherwise we are just guessing what is in your file, what you have done with it, and what effect you are expecting. If I had been using the method proposed by Ravinder, I would have specified a light red fill for the cell if the conditions were met. I do not know what format you specified so I don't know what you were expecting. RegardsDavid Grugeon On 7 December 2012 05:56, Ahmed Ab <abab19800...@gmail.com> wrote: Ravinder Negi Thanks for your support , But it does not work Regards Ahmed On Thursday, December 6, 2012 1:50:24 PM UTC+3, Ahmed Ab wrote: Hi group , Actually I am new here , And I am asking for you support Attached file has table for lease , I am searching for the possibility to get alarm from excel before the due date by certain period (i.e one week before , two weeks ,....) Thanks for all -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Lease.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet