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!
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Watch MrExcel Video

Forum statistics

Threads
1,109,005
Messages
5,526,233
Members
409,689
Latest member
martin_br

This Week's Hot Topics

Top