Conditional formatting

Copper Contributor

Hi there

 

I'm no expert on excel and I'm after some help please! I have a series of campaign plans in excel and need them to feed into a main plan, they included columns such as the activity and months and I've used a colour to block out the months that the activity is in progress and another to block out when the project is live.

 

How can I feed all of the individual campaign plans into the main plan? I only want the 'main project' information to feed through so have created a column entitled 'Category' which will be populated with either 'main projects' or 'sub projects'.

 

thanks in advance

Cat A

0 Replies