Excel Macro to Format Group sheet with colour code at specific level

_Google

New Member
Joined
Feb 6, 2013
Messages
40
Hi Guru's

Looking forward to solve below tidous work by using macro

Problem

I have a excel file which runs for more than 400 row and it is grouped at five nodes ( levels ) and at each level there is variable input items and at each level, I need to give specifc colour every time there is change addition or deletion of new item.

Is there a macro which can help to format full sheet if there is addition of or deletion of the item. One way i am looking is keep an Master sheet ( sheet1) without formating where I can add the data for level as required and macro later can format the same in another sheet ( Sheet2)

Below is example of sheet which I have exloded at 3 level , can use insight later to add remaining levels at my end by editing the macro.

level 1 = green, Level2= Blue , Level 3= Yellow colour code
Level A
Level A1
Level A11
Level A2
Level A21
Level B
Level B1
Level C
Level C1
Level C11
Level C2
Level C21
Level D
Level D1
Level D11

<tbody>
</tbody>
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Forum statistics

Threads
1,213,520
Messages
6,114,099
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top