Respected all Can some body help me in this queries
---------- Forwarded message ---------- From: big smile <bigsmile...@gmail.com> Date: 4 January 2016 at 17:26 Subject: $$Excel-Macros$$ Merge cell entries & flash cell for conditional formatting -- Can any body please help me out To: excel-macros@googlegroups.com ---------- Forwarded message ---------- From: big smile <bigsmile...@gmail.com> Date: 3 January 2016 at 12:19 Subject: $$Excel-Macros$$ Merge cell entries & flash cell for conditional formatting To: excel-macros@googlegroups.com Respected Excel Masters Thanks a lot Abhishek Jain & Leonardo Mezavilla God Bless you my friends It works properly I have also enclosed corrected files so that it can help some one It also save my lot of time now. Some still queries 1] If u see my formula in -- D3 I have to use many time same text i.e. -- $G$3Alt+Tab can we have some solution that if I put in one cell then [ $G$3Alt+Tab ] & I have to simply use that cell every time then it automatically use $g$3Al+ Tab 2] In Cell - D 15 I have to always put cell which I have added last & then I can copy to my Gmail Contact note Can we have solution for this as -- what ever is last added/corrected in any cell cell or in the Column D --- it automatically comes in the cell d15 Or can u make any macro which I run ex -- I use Ctl + A then last added/ corrected cell automatically displaced in d15 If it can be done without macro then it will be more helpful 3] Can we have conditional formating like if my due date comes --- F -coulm entry near 15 days of today then automatically full raw turns to yellor or other colour Ex -- full Raw 6 turns to any choice colur if --F6 comes near 15 days of today.. 4] Or Due Date Cell Flash/ Blink if due date is near 15 days Kindly share the formula or way out so that I can use same formula in other files too Thanks in advance -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
SAMPLE FILE.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
