Hello,

I've just joined this forum today. Hoping someone can guide me with a formatting challenge please.

I'm using Excel 2010 as a planning tool (I use MSP but my team don't have access to it so I need them to complete an xls which I will then upload into MSP). They like the template and now want to use their individual plans like a Gantt. I'd like to set a conditional format that recognises the start and end dates and colours the appropriate cells. Ideally I'd like to do this without having to put a formula in every cell - is there a way I can do this using conditional formatting that anyone knows?

It's been a couple of years since I last had to get my head around formulas so I may be way off track here.

I've attached a basic version of what I'm trying to develop - thanks for any ideas people

Attached Files

Plan Template.xlsx (47.6 KB, 13 views)