+ Reply to Thread
Results 1 to 3 of 3

Coloring alternate cells of one column in different color

  1. #1
    Forum Contributor
    Join Date
    01-26-2012
    Location
    Mumbai
    MS-Off Ver
    Excel 2013
    Posts
    154

    Coloring alternate cells of one column in different color

    Dear Experts,

    Would love some help in this project
    Basically the attached excel sheet lists out different fields with color sequencing except column I

    Of interest to me is the column I which may have any n entries , so the macro to first take into account for rows in the sheet ...basically different sheets have different number of entries and i would like to reuse the developed macro ,

    Here the different entries reflects basically different topics
    What i am seeking is a macro which color codes every alternate entry in this column some sequence
    Like Cell I2 blue , I3 green, I4 blue , I5 Green , I6 blue , I7 green ...
    Remaining sheet color sequence shall remain as it is ,

    The attached workbook has one tab titled input and other titled Output
    In the input tab , the color code is not defined for the column I entries ...in output tab , i have done the color coding i.e defined what i am expecting when the macro runs ----- for the first few entries in column I ,

    Can anyone please help ,

    Humble regards ,

    Amlan Dutta
    Attached Files Attached Files

  2. #2
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Coloring alternate cells of one column in different color

    Try:
    Please Login or Register  to view this content.
    多么想要告诉你 我好喜欢你

  3. #3
    Forum Contributor
    Join Date
    01-26-2012
    Location
    Mumbai
    MS-Off Ver
    Excel 2013
    Posts
    154

    Re: Coloring alternate cells of one column in different color

    Dear Millz,

    This works like a dream,

    Thanks so much ,

    I will mark the thread as solved ,

    Humble regards,

    Amlan Dutta

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Graph alternate coloring
    By maximpinto in forum Excel General
    Replies: 3
    Last Post: 06-03-2014, 04:16 AM
  2. [SOLVED] Fill cells with alternate color every time cell value changes
    By danex in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-03-2013, 12:19 AM
  3. [SOLVED] Alternate row color base on cells' criteria
    By alexnkc in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-22-2013, 08:17 AM
  4. Alternate color of font in two cells
    By ballan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-26-2012, 09:36 PM
  5. Alternate row coloring in CurrentRegion
    By BBoydAnchor in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-29-2011, 05:40 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1