Mr. Sam yes I understand u, at first some of the top rows I copy the badge nos with the fill handle.
The badge nos changed like : 1 105427 5-Oct-11 salnap 1 2 105428 5-Oct-11 trachisa 6 In the Sr. no 2 the badge no should be 105427 only, same like the first one. I did not check it before sorry. But the logic is clear to u I think so. Regards, Muneer, CC.... ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Sam Mathai Chacko Sent: Thursday, March 08, 2012 9:58 AM To: [email protected] Subject: Re: $$Excel-Macros$$ conditinal formatting - based on date col.....(plz help) :) I understand that! I am asking for the logic Regards, Sam On Thu, Mar 8, 2012 at 12:26 PM, Mohammed Muneer <[email protected]> wrote: Dear Sam, Thanx for reply, Conditional formatting to change the color. Regards, Muneer, CC... ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Sam Mathai Chacko Sent: Thursday, March 08, 2012 9:48 AM To: [email protected] Subject: Re: $$Excel-Macros$$ conditinal formatting - based on date col.....(plz help) A few rows on the top has a logic that is different from the logic in a few rows below. Either that, or I am not able to understand your conditional format rule. Please let us know what is the logic used. Regards, Sam On Thu, Mar 8, 2012 at 11:36 AM, Mohammed Muneer <[email protected]> wrote: Friends plz, formula through conditional formatting can be applicable. Now I am doing it manually everytime the date change. Regards, Muneer, CC... -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------ ------------------------------ To post to this group, send email to [email protected] -- Sam Mathai Chacko -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------ ------------------------------ To post to this group, send email to [email protected] -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------ ------------------------------ To post to this group, send email to [email protected] -- Sam Mathai Chacko -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------ ------------------------------ To post to this group, send email to [email protected] -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to [email protected]
