I'm working on rebuilding a yearly vacation planner (based on May-April, our vacation planning year) that our organization uses and am looking for help on conditional formatting. I've been asked to keep the previous formatting, which is why I have the pivot-based calendar appearing in the top part of the document, but also to add functionality for staff to mark off individual vacation days with the appropriate amount of hours in row 12 downwards (each row will represent one employee).
What I would LIKE to do is, when Emp1 marks that they are taking 7 hours of vacation on May 1 2018 in row 12, conditional formatting is applied on the matching date in the calendar at the top--in other words, if they mark 7 hours on May 1 2018 in cell H12, merged cell AA4:AD4 representing May 1 2018 on the calendar bolds, or something like that. I am absolutely unable to figure out the formula for this, though, especially considering I really don't feel like inserting 365/6 individual conditional formatting rules for every day of the year... is there some way to do this with a specific range (say, a whole month, so H4:AL9 for May) or maybe one row at a time for the whole year?
What I would LIKE to do is, when Emp1 marks that they are taking 7 hours of vacation on May 1 2018 in row 12, conditional formatting is applied on the matching date in the calendar at the top--in other words, if they mark 7 hours on May 1 2018 in cell H12, merged cell AA4:AD4 representing May 1 2018 on the calendar bolds, or something like that. I am absolutely unable to figure out the formula for this, though, especially considering I really don't feel like inserting 365/6 individual conditional formatting rules for every day of the year... is there some way to do this with a specific range (say, a whole month, so H4:AL9 for May) or maybe one row at a time for the whole year?