Fwd: $$Excel-Macros$$ Colour the Group Rows

Hello, Amazing macro Thanks a lot -- Forwarded message -- From: Vaibhav Joshi Date: Fri, Jan 30, 2015 at 7:01 PM Subject: Re: $$Excel-Macros$$ Colour the Group Rows To: "excel-macros@googlegroups.com" Hi Check this...I have created to Macros, one for clearing for

Re: $$Excel-Macros$$ Colour the Group Rows

Hi Check this...I have created to Macros, one for clearing format, press erase me button & sleect range from which you want to delete formatting/colr.. And to apply color formatting, press color me & slect top most cell e.g.A2 in your case & press enter..Macro will color cell as per ur requiremen

Re: $$Excel-Macros$$ Colour the Group Rows

Hello yes after every group there is one space On Fri, Jan 30, 2015 at 5:28 PM, Vaibhav Joshi wrote: > Hi > > For macro need some input, is there gonna be space between two groups? > ᐧ > > On Fri, Jan 30, 2015 at 5:19 PM, Ganesh Acharya < > acharyaganesh...@gmail.com> wrote: > >> Thanks a lot f

Re: $$Excel-Macros$$ Colour the Group Rows

Hi For macro need some input, is there gonna be space between two groups? ᐧ On Fri, Jan 30, 2015 at 5:19 PM, Ganesh Acharya wrote: > Thanks a lot for your help team > > Really you are amazing, > > I tried this before, but I want to highlight all the group at one go, > > Because file is huge, I

Re: $$Excel-Macros$$ Colour the Group Rows

Thanks a lot for your help team Really you are amazing, I tried this before, but I want to highlight all the group at one go, Because file is huge, I have to create many formula, One which I provided that is just an example If something sort of Macro would be really good Again Thanks a lot for

Re: $$Excel-Macros$$ Colour the Group Rows

Dear Ganesh, Go in Conditional Format tab and click on Manage Rules option and try to understand how the formula works. I think, you no need a macro for it. Regards Ashish -- 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 Faceboo

Re: $$Excel-Macros$$ Colour the Group Rows

Forwarded message -- > From: Vaibhav Joshi > Date: Fri, Jan 30, 2015 at 2:29 PM > Subject: Re: $$Excel-Macros$$ Colour the Group Rows > To: "excel-macros@googlegroups.com" > > > Hi > > You can do with countifs & count formula..for each group you need to

Fwd: $$Excel-Macros$$ Colour the Group Rows

Hello, Attachment doesn't have any formula Is there any way to make a Macro for that Thanks Ganesh Acharya -- Forwarded message -- From: Vaibhav Joshi Date: Fri, Jan 30, 2015 at 2:29 PM Subject: Re: $$Excel-Macros$$ Colour the Group Rows To: "excel-macros@google

Re: $$Excel-Macros$$ Colour the Group Rows

Vaibhav Bhai, Nice Solution. Regards Ashish -- 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 ti

Re: $$Excel-Macros$$ Colour the Group Rows

Hi You can do with countifs & count formula..for each group you need to have diff. conditional formatting.. Check this attachment.. ᐧ On Fri, Jan 30, 2015 at 1:50 PM, Ganesh Acharya wrote: > Hello Expert > > > I am having some issue in highlighting the rows with there in goup > > > Please fi

$$Excel-Macros$$ Colour the Group Rows

Hello Expert I am having some issue in highlighting the rows with there in goup Please find the attachment >From the Data, would like to highlight those row which has same* Product Number and same Item side Name*. but it should be in the *same group* In the* group if it has* Same product n