Hi All
I'm trying to get the conditional formatting right in my schedule worksheet.
There are three rows for each calculation. The first row holds the start date , the second shows amount of weeks between and the third holds the end date.
Essentially , I'd like all three to grey out once the current month and year in the third one has passed.
For example: B , C and D would grey out once the month and year have in D passed.
I'd like this to apply right across all the worksheets in the workbook for each group of three rows.
Can someone help with a formula?
I'll attach the workbook.
Grateful for your help.
![]()
Bookmarks