Annual PM Gantt Chart by week and conditional formatting

Pamir

New Member
Joined
Jan 16, 2017
Messages
1
Hello,

I am new to this board as of this morning and here hopefully with your help to save my life :).

I am stuck at work trying to create a detailed work plan for the entire year for my project. I have used conditional formatting before for small gantt charts, but now need to create an extensive one. My question is-is it possible to use If function/conditional formatting for WK1, WK2, WK 3 and etc (as opposed to having specific dates i.e. 16th Jan, 15th Jan).

My yearly workplan will look similar to this. January and all the Weeks (WK) under January. Is there any way to include start and end date for the corresponding weeks and use if function-conditional formatting, rather than highlighting the columns for the weeks manually.
Task 1January
Meeting1Wk1WK2WK3
Meeting 2
Meeting 3

<tbody>
</tbody>



<tbody></tbody>
Thank you so much for saving my life!
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Watch MrExcel Video

Forum statistics

Threads
1,132,878
Messages
5,655,766
Members
418,236
Latest member
jess5789

We've detected that you are using an adblocker.

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.
Go back
Top