 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
I'm trying to create a programme (gantt chart) in excel as I dont have MS Project.
I've got a list of dates across the top (sequential days)
I have start and completion dates in 2 columns down the sides, ie
Start End 5 Nov 6 Nov 7 Nov 8 Nov
6 Nov 7 Nov
I want excel to format (colour fill) the cells between the start and end dates, ie in the example above the cells below 6 Nov and 7 Nov in the top row.
I think I need to use a formula rather than one of the standard options, but can't figure out how to do the conditional expression.
Any suggestions?
Ta
With start dates in column A, end dates in column B, calendar from C1 onwards then formula in C2 (and copy&pasted across GANTT) is
=AND($A2<=C$1, $B2>=C$1)
Stoner, have a 😀
Thanks!
prego.
Bit of a hijack, but is there a way of highlighting a bunch of cells and entering a conditional formatting formula just the once? Whenever I try, it just formats the entire selection based on the first cell's formula conditions, so I have to enter the formula in each individual cell.
The default is an absolute reference (such as $A$1) so you need to muck about with the $ signs so it copies as you wish.
A colleague recently sent me a link to this:
http://www.vertex42.com/ExcelTemplates/excel-gantt-chart.html
(sorry for lack of link, work blocks pop ups)
It does work, but I reckon there's space for lots of improvements!
Edit: Hmm Aparently I can do links!!
@Flying Ox - probably easiest to do copy / paste special / format - as above you need to make sure the referencing (if any) in the condition format changes as you expect when doing the copy / paste