gantt charts

[John_EHDS]

Hi All

 We have a simple Gantt chart that I downloaded,  We plan our jobs on the chart based on start and end dates. We choose the start date based on the availability of staff,

We would like to be able to colour the columns based on the dates that staff are available to help us plan the jobs.

We can do this manually but when we change the date range the colours do not move with the dates.

So Im sure this is simple I just don't know how to do it.

So simply, I want the colours to move with the columns associated with the dates so that when we change the date range the coloured columns move with the dates.

I hope this makes sense, I can send you a copy of the blank chart if you need it

Thanks in advance to any one who can help with this.

[#2]

Hi @John_EHDS 

yes, this could usually be solved with conditional formatting. If you would upload your file (without any sensitive data, just with some example data), then we can give a more precise advice.

[#3]

@Martin_Weiss 

Hi Martin.

Thanks for getting back to me.

I can upload a copy of the Gantt chart I downloaded, with a copy of what we want it to look like

Do you know hi I can attach the files?

[#4]

@JohnEHDS 

When you compose a reply, you may see an area below the space where you type labeled "Drag and drop here or browse files to attach".

If you don't see that, you can upload your sample workbook to a cloud store such as OneDrive, Google Drive, Dropbox, then obtain a link to the uploaded file and post that link in a reply.

You can also send Martin a Private Message and attach the workbook to the message.