Highlight Rows in one sheet with the same colors of Tabs in another Sheet

[vir8nitkkr]

Hi,

I have extracted data from different tabs of a sheet named 'Hobby Card Macro Enabled.xlsm' into different corresponding rows of another sheet named 'Admission Database.xlsm'. I want that even the color of rows in 'Admission Database.xlsm' is same as the color of their corresponding tabs in 'Hobby Card Macro Enabled.xlsm'.

The names of various tabs in 'Hobby Card Macro Enabled.xlsm' are in serial order like Roll-1, Roll-2, Roll-3 and so on. In 'Admission Database.xlsm', row 1 corresponds to Roll-1, row 2 corresponds to Roll-2 and so on.

What formula should I use? Please help.

 

[mole999]

what drives the colours of your rows on you first sheet

 

[vir8nitkkr]

If there is this word 'Due' in Column A of a sheet then I change the color of the tab to Red.

 

[vir8nitkkr]

Also, can you please tell me how to automatically change the color of the tab (for n number of tabs).

 

[vir8nitkkr]

Please Correct 'Column A' with 'A19 to A200'. Also, if any of the cells 'C18, D18, E18, F18, G18, H18, I18, J18' has a positive value, the tab color should change Red, followed by change in color of row of the other sheet (Admission Database.xlsm).