I have 2 columns with dates (Col1, Col2) and columns with quarters.

I need to color cells in quarter columns grey if the quarter in a particular quarter column falls out of the date range in Col1 and Col2.
For example: Col1=8/1/13, Col2=9/1/13
since the date range is in Q3, cell in Q3 column will stay white, while Q4 column will be colored grey since Q4 is outside of the specified date range.


Please see attached example. Conditional formatting formula in the file works except the cases where the date range specifies multiple quarters and multiple cells need to be white (case that does not work in red).

Any help would be greatly appreciated!
CONDFORMAT.xlsx