Forum Discussion
Solved
Conditional Formatting for Quarters & Years
Hi all, I had a spreadsheet that had months along the top and used conditional formatting to colour in the cells between the start and finish date using the formula: =AND($C5<=E$2,$D5>=E$2) and i...
I'd use a slightly different setup.
You can then use the original formula in the conditional formatting rule:
Thanks. Does the attached version work for you? I changed the formula in the conditional formatting rules so that a cell is highlighted if the time periods overlap a date range instead of being contained in the range.
yes it does. thank you so much!