time scale on timeline

Hallo!

I established a timeline chart by using conditional formatting. The scale I used are the calender weeks of the year.
I have a column for the start and ending date of an action and according to this the cells get colored on the timescale.
However if an action is less than a week excel doesn't highlight that at all.
I can not change the scale to single days because I would run out of columns for the time period I have to cover.

This is the formula I used: IF(AND(E$5>=$C8,E$5<=$D8),1,"")

(1 equals in the conditional formatting to highlight the timeline grey)
E5 is a cell on my calender weeks scale
C8 and D8 are the beginning and the start date of the action

does anybody know a solution?

thanks

Hello schicadellic [great name]

For starters, if you're using that formula in conditional formatting then there's no need for an IF function, just

=AND(E$5>=$C8,E$5<=$D8)

will suffice

If I understand correctly then you could change to

=AND(E$5+6>=$C8,E$5<=$D8)

This should highlight your dates should any part of the action fall within that week. Of course this would mean that even a 2 day action could fall into 2 weeks.....

Thanks a lot...that was just what I needed.

If I ever see u in person I owe u couple of beers for that

ciao