Hi
I'm pretty new at using Excel and I have NO idea how to do what I want to.
I've joined my spreadsheet for better understanding.
In the "Horaire" tab
I want to fill with color with conditional formating in my calendar on the left the statutory day the date that are listed in the table on the right.
Thx
Just realised I cant post attachment (anyone know why?) so I'll try to simulate my spreadsheet here.
TABLE 1
______ 1 2 3 4 5 6 ............. 31
January X
February
March
........
December
Table 2
STATUTORY DAYS
Holiday ____Month________ Day
New Year__ December______ 1
......... ........ ...
I want the the cell (the one with the green X here) to be color filled conditionaly with the values in the table #2
Hope that's clear.
Thx
I'm pretty new at using Excel and I have NO idea how to do what I want to.
I've joined my spreadsheet for better understanding.
In the "Horaire" tab
I want to fill with color with conditional formating in my calendar on the left the statutory day the date that are listed in the table on the right.
Thx
Just realised I cant post attachment (anyone know why?) so I'll try to simulate my spreadsheet here.
TABLE 1
______ 1 2 3 4 5 6 ............. 31
January X
February
March
........
December
Table 2
STATUTORY DAYS
Holiday ____Month________ Day
New Year__ December______ 1
......... ........ ...
I want the the cell (the one with the green X here) to be color filled conditionaly with the values in the table #2
Hope that's clear.
Thx