Re: $$Excel-Macros$$ Changing Color

2013-04-05 Thread Chaya
Thank you very much Anil Sir and abhishek sir, Code are working fine. thanks a lot. Regards, Chaya On Fri, Apr 5, 2013 at 1:00 PM, अनिल नारायण गवली wrote: > Pl see the attached sheet. > > Warm Regards, > Just run the macro. > Gawli Anil > > > On Fri, Apr 5, 2013 at 12:57 PM, Abhishek J

Re: $$Excel-Macros$$ Changing Color

2013-04-05 Thread अनिल नारायण गवली
Pl see the attached sheet. Warm Regards, Just run the macro. Gawli Anil On Fri, Apr 5, 2013 at 12:57 PM, Abhishek Jain wrote: > See this. > > > On Fri, Apr 5, 2013 at 12:42 PM, Chaya wrote: > >> Thanks Abhishek Sir, >> >> Actually, where ever the colour of the D cloumn exist or the >

Re: $$Excel-Macros$$ Changing Color

2013-04-05 Thread Abhishek Jain
See this. On Fri, Apr 5, 2013 at 12:42 PM, Chaya wrote: > Thanks Abhishek Sir, > > Actually, where ever the colour of the D cloumn exist or the > cell colour of the D column exist, the same corresponding colour should be > obtain to the corresponind row in A, B, C COLUMN. > > Say exam

Re: $$Excel-Macros$$ Changing Color

2013-04-05 Thread Chaya
Thanks Abhishek Sir, Actually, where ever the colour of the D cloumn exist or the cell colour of the D column exist, the same corresponding colour should be obtain to the corresponind row in A, B, C COLUMN. Say example: D10 - is Green and as per condition, A10, B10 and C10 should als

Re: $$Excel-Macros$$ Changing Color

2013-04-04 Thread Abhishek Jain
Does this help ? On Fri, Apr 5, 2013 at 11:06 AM, Chaya wrote: > Dear Experts, > > Hope you are well !.. i am trying to change the colour of the row by > the corresponding cell value by conditional format. but i have very least > idea on this regards, for reference i have attached by query