Hi Sonia, If you open the VBE window, u will see a for each loop, that is changing the cell color for all the selected cells.
Let me know if more clarification is required. :) Thanks & Regards, Harmeet Singh Sent via BlackBerry Wireless On Wed, Sep 23, 2009 at 1:34 PM, Sonia Singla <sonia...@gmail.com> wrote: > Hi harmeet > > One thing more is, its working only when cells contain numerical data but > what about when cells contain text. > > Sonia > > On Wed, Sep 23, 2009 at 9:53 AM, Sonia Singla <sonia...@gmail.com> wrote: > >> Hi harmeet >> >> Thanks yar but can u explain me how is it working. >> >> Sonia >> >> On Tue, Sep 22, 2009 at 4:32 PM, Harmeet Singh < >> harmeet.hew...@gmail.com> wrote: >> >>> *Hi Sonia,* * >>> * >>> *Thanks for appreciation.* >>> * >>> * >>> *Please note that, the macro provided by me will work for N x N matrix.* >>> * >>> * >>> *Fro reference I have attached the macro file.* >>> * >>> * >>> *You just need to click on the button when the file opens.* >>> * >>> * >>> *Thanks & Regards, >>> >>> **Harmeet** Singh >>> >>> Sent via **BlackBerry** Wireless >>> >>> * >>> On Tue, Sep 22, 2009 at 1:29 PM, Sonia Singla <sonia...@gmail.com>wrote: >>> >>>> Hi Harmeet >>>> >>>> thanks for your reply. I have already made a macro if the data is in nX1 >>>> but i was unable to make a macro if we have a data in nXm matrix. >>>> For example please see the attached file. >>>> >>>> Thanks and regard >>>> Sonia >>>> >>>> On Mon, Sep 21, 2009 at 7:05 PM, Harmeet Singh < >>>> harmeet.hew...@gmail.com> wrote: >>>> >>>>> *Updated one..........* >>>>> * >>>>> * >>>>> Thanks & Regards, >>>>> >>>>> Harmeet Singh >>>>> >>>>> Sent via BlackBerry Wireless >>>>> >>>>> >>>>> On Mon, Sep 21, 2009 at 6:40 PM, Sonia Singla <sonia...@gmail.com>wrote: >>>>> >>>>>> Hi >>>>>> >>>>>> I have the data in an array say in nXm. I want to make a macro color >>>>>> the cells with the same color having the same next. >>>>>> >>>>>> for example cells having 2 should have color red, cells having 5 >>>>>> should have color blue etc. >>>>>> >>>>>> Thanks >>>>>> Sonia >>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>> >>> >> > --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
