Hello All -
I have manually created a calendar in a spreadsheet with Weeks as columns as specific tasks in rows
I have another worksheet that has a bunch of data including the specific tasks and "planned date".
I would like the calendar to automatically conditional format the week if there is a planned activity for that specific task.
Ultimately, the logic I need to use is as follows:
If In WorkSheet Column A, the Value (date) >=Date1 <=Date 2
And IF WorkSheet A, Row B, Row Text = "Text String"
Conditional Format WorksheetB (the calendar) the specific row/column = Green
I would need this formula across each week (ideally without having to manually manipulate each (>=date 1 <=date 2)
I have tried building this out but realized I am out of my depth. Anybody done this before?
Thanks
Dan
Bookmarks