#1
|
|||
|
|||
Excel 2010 Format cells to use as Gantt or Plan
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 |
Tags |
conditional format, excel 2010, gantt |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to create microsoft Excel 2007 and 2010 File in .xlsx format | ipacesetters | Excel | 1 | 12-16-2019 05:13 PM |
how to set up plan with no duration info? | stats | Project | 1 | 04-11-2010 04:12 PM |
Gantt Chart: MS Project vs. Excel | Nance | Project | 2 | 12-09-2008 01:59 PM |
format cells to automatically place quotes around text | dirtleg | Excel | 1 | 09-16-2008 01:52 PM |
Business plan maker | unknowngiver | Office | 6 | 06-06-2005 04:25 PM |