Cell Formatting Issue - Background Color

[norseman1]

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

[6StringJazzer]

How do you determine whether the name in a cell is an CAD tech name or an Engineer name?

I suspect that conditional formatting will be a better solution for this than code. The .Interior.Color attribute of a cell is the background color. You can assign colors to it using RGB:

' Set background color to red
Range("A1").Interior.Color = RGB(255, 0, 0)

As usual, it would help to attach your file.