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