Creating a calendar to be shared with multiple teams. I wanted to use conditional formatting to show whether a project was not yet started, in progress, or complete, as well as color-code tasks. However, it was way too many conditions and started crashing my workbook. I'm trying to see if there is an alternative by using VBA and I'm wracking my brain trying to figure it out.
All tasks are listed on a master "task" sheet and pulled into the cells of the calendar using the following formula:
Would it be easier to format this master sheet then have a VBA copy and paste the task description into the proper date on the calendar? Or to leave the current formula as-is and create VBA to format each cell based on the criteria? (There can be multiple tasks on any given date and there are checkboxes at the beginning of the calendar allowing user to toggle viewing certain tasks).
All tasks are listed on a master "task" sheet and pulled into the cells of the calendar using the following formula:
Excel Formula:
=IFERROR(INDEX(Tasks[DESCRIPTION],SMALL(IF(DATEVALUE(TEXT(B$5,"mm/dd/yyyy"))=Tasks[CORRECTED],IF(Tasks[SHOW]=TRUE,ROW(Tasks[DESCRIPTION])-4,"")),ROW()-5)),"")Would it be easier to format this master sheet then have a VBA copy and paste the task description into the proper date on the calendar? Or to leave the current formula as-is and create VBA to format each cell based on the criteria? (There can be multiple tasks on any given date and there are checkboxes at the beginning of the calendar allowing user to toggle viewing certain tasks).
