Timeline Conditional Formating

[lavezzi7]

Hi Guys,

I have created an automated timeline in Excel and but I would like to have conditional formating between the starting date and the end date:

https://ibb.co/WfnjvPq

I would like to be shown as a bar basically, thus the cells in between SD and ED shall be automatically yellow. Perhaps can be made in another way. Any ideas?

 

[etaf]

what do the numbers 1 to 5 mean ?

 

[lavezzi7]

THe number of the week, any ideas?

 

[Fluff]

Not sure why you have ED in week 5 as 10th Feb is week 7
If that's a mistake you can try
=AND(C$2>=WEEKNUM($A3),C$2<=WEEKNUM($B3))

Excel 2013/2016
	A	B	C	D	E	F	G	H	I	J	K	L
1
2			1	2	3	4	5	6	7	8	9	10
3	01/01/2019	10/02/2019	SD				ED
4	15/01/2019	24/02/2019
Cover