Represent two given dates as a timeline - help

[winrz]

I am using the conditional formula
=AND(J$4>=$F5,J$4<=$G5)
J4-T4 represent Jan - Dec
F column is start date
G column is end date
to create a timeline from two dates (Start / End). The Start & End dates are specific (ie 4/2/02 - 8/4/02) but the comparison dates along the top of the chart are for a given month (ie 1/1/02, 2/1/02, etc)and not a range so that when the condition is true it colors the whole cell for that month.
The problem is - if the start date is 2/15/02 - the Feb cell wont be shaded since the heading 2/1/02 is not greater than or equal to. 2/1/02 will be shaded - but nothing else for the month. Do i need an 'or' somewhere in there? I have lockjaw of the brain now...

 

[lenze]

I played around with this same situation a couple of years ago developing Gantt Charts for project tracking. If you wil post or PM me your email, I will send you the template. I think the conditional formatting formulas will give you an idea of how to proceed.