Hi,
I am trying to make a GANTT using Excel as shown below using Conditional Formatting to show the Plan Start - Plan Finish, what conditional formatting arguments do i need to enter to account for an over run in the Actual Finish. i.e if the Stage 1 - Initiating should have finished at wk4 but it actually finished at wk 5 id like the week 5 to be a different colour so i can call this in the key "Task overrun" or something like that. Also is there anyway that if the percentage is 100% it turns the coloured bar another colour denoting complete.
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)
Can you also use XL2BB (see below) to show us what the end results would look like after you have filled the desired cells with colour manually?
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in
Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.
Not quite. I would like to see the expected Gantt chart. Instead, can you manually fill in the colours on your worksheet as you would want and then take a snip of that and paste that into a post here so we can see your goal?
If you can, include the column and row labels in your snip so we can see just where things are?
Thanks for the image. See if this is what you want then.
Not sure what you would want if Actual Start was later/earlier than Plan Start or if Actual Finish was before Plan Finish.
If any of those are possible I would want to see examples of the colours you would want for each situation.
Thanks for the previous replies, i have a further query would it be possible using the conditional formatting for the GANTT bars to match the Progress column colours i.e if the progress is 0% its is a red fill, between 1 and 99% its a green fill and 100% its a purple fill.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
