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.
<tbody>
</tbody>
<tbody></tbody>Thank you so much for saving my life!
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 1 | January | ||
Meeting1 | Wk1 | WK2 | WK3 |
Meeting 2 | |||
Meeting 3 |
<tbody>
</tbody>
<tbody></tbody>