Macro for changing tab color

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I have a list that prints out every day with different goals listed for people who work with me. I have a worksheet for each person on Excel 2007. I am trying to figure out an easy way using macros to change the tab color of people who actually work that day so I can easily identify which worksheets to print each morning.

I know a little bit of basic programming from classes in school and realize that using a macro with an If/Else function would be the easiest to change the tab colors, but I honestly have no clue as to how to setup the macro for each worksheet to allow for the tab color to change whenever the data is updated into the sheet.

Also the worksheets are a basic template that will be auto-filled from various data sheets already in the workbook.

So just for clarity I'm looking to change the tab color only if the sheet is populated with new info, so example if the name is in cell B2, I would only have the tab color change when B2 is not blank (which is where I figured that an IF/ELSE function would be the easiest to use for the given situation).

Any basic form would be awesome, I'm sure I can adapt it to every worksheet. I just really need a strong foundation to start on.

Thanks,

Cam



1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too