Re: $$Excel-Macros$$ regarding font color based condition

2012-05-29 Thread Sanjib Chatterjee
Dear Sir, I have go through the below mentioned link. but i can not understand. Would you please explain why we need to use the *=Get.cell(24,indirect("RC[-1]",)) function? Another how to use the formula in other sheet. regds, sanjib * On Tue, May 29, 2012 at 3:26 PM, NOORAIN ANSARI wrote:

Re: $$Excel-Macros$$ regarding font color based condition

2012-05-29 Thread NOORAIN ANSARI
Dear Sanjib, Please check below link..* *Hope it will help you to use Get.Cell Function. * http://www.sulprobil.com/html/get_cell.html* -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, May 29, 2012 at 3:23 PM, Sanjib Chatterjee < chatterjee.kol

Re: $$Excel-Macros$$ regarding font color based condition

2012-05-29 Thread Sanjib Chatterjee
Dear Nooranin Ansari, This is working fine. But would you explain the below mentioned formula. You have mentioned the formula outside the date zone even. If i want to use the formula in another sheets how to use it? Waiting for you reply. Regards, Sanjib On Tue, May 29, 2012 at 3:08 PM, N

Re: $$Excel-Macros$$ regarding font color based condition

2012-05-29 Thread NOORAIN ANSARI
nd plz let me know how > can we know abt these functions.? > > > -- > Date: Tue, 29 May 2012 15:08:34 +0530 > Subject: Re: $$Excel-Macros$$ regarding font color based condition > From: noorain.ans...@gmail.com > To: excel-macros@googlegroups.com

RE: $$Excel-Macros$$ regarding font color based condition

2012-05-29 Thread danial mansoor
how do u know abt this get function?wat it does?and plz let me know how can we know abt these functions.? Date: Tue, 29 May 2012 15:08:34 +0530 Subject: Re: $$Excel-Macros$$ regarding font color based condition From: noorain.ans...@gmail.com To: excel-macros@googlegroups.com Dear Sanjib