I'm trying to construct a Gantt chart using conditional formatting. However, I am working with a data range in months on the 'Y' Axis, and columns that indicate Quarters.
I get that I can construct an 'If And' formula to match my monthly date range to a specific Quarter, but am running into trouble when my monthly date range falls into two or more quarters.
For example, I have a project component that begins in February 2015, and ends in June 2015. Along the 'X' axis, my conditional formatting should highlight those columns that match Q1 2015 and Q2 2015. My simple 'If And' formula doesn't work because the date range exceeds one quarter.
Any thoughts?
<colgroup><col width="53"><col width="52"></colgroup><tbody>
[TD="class: xl64, width: 52"][/TD]
</tbody>
I get that I can construct an 'If And' formula to match my monthly date range to a specific Quarter, but am running into trouble when my monthly date range falls into two or more quarters.
For example, I have a project component that begins in February 2015, and ends in June 2015. Along the 'X' axis, my conditional formatting should highlight those columns that match Q1 2015 and Q2 2015. My simple 'If And' formula doesn't work because the date range exceeds one quarter.
Any thoughts?
<colgroup><col width="53"><col width="52"></colgroup><tbody>
[TD="class: xl64, width: 52"][/TD]
</tbody>