Conditionnal formating in VBA

[stoure]

Hi!
I've a conditionnal formatting formula in EXCEL, I'd like to use macro to do so. Thanks.

=SOMMEPROD(($C$5>=INDIRECT("Leave[departure]"))*($C$5<=INDIRECT("Leave[return]"))*($B8=INDIRECT("Leave[workers]")))

applied on

=$C$8:$G$14

I'd like to do it on the table below with colour... Thanks

	Monday 01	Tuesday 02	Wednesday 03	Thursday04	Friday 05	Saturday 06	Sanday 07
start	00	06	13	18	20	00	06	13	18	20	00	06	13	18	20	00	06	13	18	20	00	06	13	18	20	00	06	13	18	20	00	06	13	18	20
end	06	13	18	20	00	06	13	18	20	00	06	13	18	20	00	06	13	18	20	00	06	13	18	20	00	06	13	18	20	00	06	13	18	20	00
agent1	X							X				X			X	X							X				X			X	X
agent2		X			X	X							X				X			X	X							X				X			X
agent3			X				X			X	X							X				X			X	X							X
agent4		x			X	X							X				X			X	X							X				X			X
			X				X			X	X							X				X			X	X							X
	Semaine du 08/01 au 14/01 2018
	lundi 08	mardi 09	mercredi 10	jeudi 11	vendredi 12	samedi 13	dimanche 14
debut	00	06	13	18	20	00	06	13	18	20	00	06	13	18	20	00	06	13	18	20	00	06	13	18	20	00	06	13	18	20	00	06	13	18	20
fin	06	13	18	20	00	06	13	18	20	00	06	13	18	20	00	06	13	18	20	00	06	13	18	20	00	06	13	18	20	00	06	13	18	20	00
agent1
agent2
agent3
agent4

<colgroup><col><col span="13"><col><col><col span="20"></colgroup><tbody>
</tbody>