so I have this workbook that I am trying to figure out how to manage in a more automated way.
I have 2 main sheets. In 'Sheet2' there are 4 columns (Item, Sub-Item, Start, End). In 'Sheet1' there is similar data just formatted differently. Each valid permutation of Item and Sub-Item is already listed and the dates are expanded. Under each permutation of item/subitem I want to be able to enter 'True' if the date is affected and have it highlight any matching affected rows in 'Sheet2'. To be a match it needs to match the Item and Sub-Item and have a highlighted date that falls within the date range (exclusive of the End date) in 'Sheet2'. It doesn't have to be done in google sheets, it could also be done in excel if that makes it any easier or different.
I've linked a sample sheet below. Hopefully that helps clear up any questions.
