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
Bookmarks