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:
Rule formula could be
=( (LOOKUP(9999,$G$3:G$3)*10+G$2) >= ($C13*10+$E13))*( (LOOKUP(9999,$G$3:G$3)*10+G$2) <= ($D13*10+$F13))which gives