Automated formatting from basic Excel to fancy Excel!

Hi All,

First post here!

I have a report that I have extracted from MS Project and I want to write a macro that will fully format it so that I can hand it to colleagues that do not have MS Project, but do have Excel.

The kind of things I want to do are:

• Where a new project starts, have the row in a different colour and embolden text
• Place a new, empty row above where each new project starts

There are other things that I need to do, but I can manage these on my own. I looked at using conditional formatting, but I only managed to format the cell I was selecting. I am thinking the answer may be in VBA scripting?

Any help or advice is appreciated!

Jimbo

VBA will probably provide a great flexibility for your formating requirements.

The best way is to record what you want to do then look at the code to see how it is written. Then you can edit it the way you want it to behave.

If you have any questions on how to do certain things, you can always post the question in the Programming section of the forum.