Hi,
I'm hoping someone knows if this is possible: I'm trying to get conditional formatting to highlight cells that match two criteria: specific date on the column and specific cell values.
I'm linking an example where I've used manual coloring to show what I'm trying to achieve. In the example file, I have six seats from A1 to A6. These seats are further divided into three groups M1 to M3. Each group has specific dates when they are reserved, and that's when I'd like to have them highlighted - but not the rest of the column, unless of course multiple groups have overlapping date info.
So I guess the logic would go to first check that group M1 is reserved on 6.9 and 9.9.2022; then check that A1 and A2 belong to group M1. Find the columns with the dates, and highlight the cells which contain what belongs to the group M1.
I'm not even sure anymore at this point if I'm approaching this the right way by using "helper" tables on separate sheet. It's just something that has very often been the key in other problems.
Thanks all!
Bookmarks