Macro for changing tab color

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