Completed Task Fill Collor

Hello,

On the Planner sheet there are tasks that have fill colors for the duration of the task. When completed with the checkbox true can the entire task be filled with the format in cell D40 which I named "Completed_Task"?

Since VBA does the fill color of the entire task based on the category can VBA be solution for the completed task fill instead of conditional formatting which only alters the first cell of the task?

Thank you for your help

You can copy the formatting of a cell/range to another cell/range using PasteSpecial like

Please Login or Register  to view this content.

Thank you jdelano but this does not make any sense for the tasks in the days of the week area.

Maybe it can't be done with VBA thanks anyway.

Replace the procedure "Schedule_Refresh" with the following:

Please Login or Register  to view this content.

and add the following code:

Please Login or Register  to view this content.

Thank you Tajan for your help. Although the code works the speed of workbook is substantially slower now. Perhaps there is too much going on.

At the beginning of the "Schedule_Refresh" procedure insert:

Please Login or Register  to view this content.

And at the end:

Please Login or Register  to view this content.

This should speed things up a bit. However, CF will always be faster than assigning a cell format.