Problem with date and/or cell formatting

[nova_sweet]

Hello!

I would need advice on cell formatting (I guess).

Having a 4-week-table with dates, I would like to automatically highlight holidays like Easter, Christmas, New Year plus a couple of extra dates like 1th of maj, 6th of june, 6th of december. The cells to format look like c1=$B1+1 (for example).

Any advice on that? I tried by formatting but it did not work at all.

Thankful for all input.
Best regards

Tble looks a bit like this, but for a whole year (4-weeks period, 14 sheets)

Name	=sheet1!$B$3 (31.12.2018)	=$B1+1 (1.1.2019)	=$C$1+1 (2.1.2019)	and so on
	mon	tue	wend

<tbody>
</tbody>

 

[nova_sweet]

Also if you select the entire range OR just the columns B:H
it will work for the cells in the other rows with dates

Assuming you are not adding dates or coincidentally numbers in the same range as a date in the other cells

No, no numbers or dates, only names/text

 

[etaf]

should be fine then
i did change a holiday date as a test to 20th jan

 

[nova_sweet]

Yes, works fine!

 

[etaf]

you are welcome