Hi all,

I have a macro that I have been working on that is pretty much done except for this formatting issue. The macro adds up all employee hours for the current week as well as hours for 8 weeks in advance. This is so I can project which employees I need to assign more hours to for upcoming projects.

The employees are broken up into two categories: Engineers and CAD Technicians. The CAD technicians' names have a blue cell background and the Engineers' names have a white cell background on the "Project Lists" Sheet. When I run my macro, I want to be able to have the CAD techs' names be highlighted in blue, but I can't figure out how to do this in VBA. The "Schedule Summary" is dynamic, so I can't simply just format the cells before I run my macro.

thank you!

-norse