Hi



I've never used Marcos until today. I have been trying to expand my knowledge with Excel as much as possible, and I wanted to automate an export I do on a weekly basis. I used the "Record macro" function to record everything I do during my formatting process (it's fantastic!).

My question is this: I am producing an export of a timeline from MS Project. Then formatting Phases with one color, sub-phases with another color, removing columns etc. As we move along with the Project itself, we have been identifying tasks that were not previously included on the timeline, and they should be. So, I will insert tasks as needed- therefore, changing my macro because due to that new line, it in turn changes the row # that it should be color formatting. I'm fine with re-recording the macro as things change, because eventually, the need to do so will become less or non-existent toward the end.

I know I can go in and edit the code accordingly each time as well, but what I was wondering is: Can I alter the code to be more specific in regards to what it will format, rather than specifying by row# or column#? For example:

Row 245: (cells read as follows) A245: 2,046, B245: 0%, C245: Data Processing, D245: 3 (the remaining data in the table ends in column H)

Can I identify in the code, that I want it to find the cell containing "Data Processing", and color that row from cell "A###:H###" ?

Additionally, part of the formatting requirements is to group the cells by Phases and Sub-Phases. Similarly, can I identify in code to find "Data Processing", and group from that row to the row containing "Process final data" (the final task in that Phase)? that is what I end up finding to be more difficult when editing what is already there- back tracking and changing which rows to group from/to.

Final question! I realized as well, when I assigned conditional formatting requirements, that it did not record that piece of the puzzle. Unless there is another way to log the conditional formatting requirements? I'm also fine with just assigning the conditional formatting after I run my macros- but if it can be automated as well- all the better

Any help is greatly appreciated!

Thanks!!
E