Conditional Formatting cells if between dates by quarter

[ashley1984]

Hi,

I'm trying to conditional format cells based on the date they fall in but by quarter. For example, if I have an initiative that starts on 5/1/21 and stretches to 20/2/21 I want the Q1 cell to be conditional formatted and filled in.

I also might have an instance where the start date would be 20/2/21 and stretch over several quarters, say to 1/7/21, or in some cases even across into 2022. Hopefully, the table below demonstrates what I need

 

[ashley1984]

Solved

 

[smozgur]

Solved

Do you mind sharing the solution so it helps future readers as well? Then you can mark your post as the solution of course.

 

[ashley1984]

Do you mind sharing the solution so it helps future readers as well? Then you can mark your post as the solution of course.

Hi, the solution is here

Conditional format if date values from two cells are within Qtr/Year Range

Hello, Thanks in advance for your help! I am looking for macro/vba to help highlight a range of cells within the quarter/year columns if date value falls within baseline start and baseline end? baseline start baseline end 2021 Q1 2021 Q2 2021 Q3 2021 Q4 2022 Q1 2022 Q2 2022 Q3 2022 Q4...

www.mrexcel.com