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)
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]=sheet1!$B$3 (31.12.2018)[/TD]
[TD]=$B1+1 (1.1.2019)[/TD]
[TD]=$C$1+1 (2.1.2019)[/TD]
[TD]and so on[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]mon[/TD]
[TD]tue[/TD]
[TD]wend[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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