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:
For some reason, it's not reading the dates correctly. It reads the single date milestones (pink/green/yellow/blue vertical columns) but not the horizontal ones. Do you know if I need to change Q1 2023 to 2023Q1 like you've done or is there a different reason?
With similar layout
rule formula could be
=( LOOKUP(9999,$G$3:G$3)&G$2 >= $C12)*( LOOKUP(9999,$G$3:G$3)&G$2 <= $D12)