Hello, for my yearly calendar I would like to change format for each day in the calendar, if the specific date is within the range of holidays.
There are several blocks of holidays.
My sheet includes several lines with different seasonal holidays, each with a first day and last day of the holidays. I have set named ranges for BeginnHolidays and EndHolidays.
I imagine that the conditional format should be something like:
=match(C5; AND(>=BeginnHolidays; <=EndHolidays;
but I get an error.
Who can solve this for me please? Many thanks in advance.
There are several blocks of holidays.
My sheet includes several lines with different seasonal holidays, each with a first day and last day of the holidays. I have set named ranges for BeginnHolidays and EndHolidays.
I imagine that the conditional format should be something like:
=match(C5; AND(>=BeginnHolidays; <=EndHolidays;
but I get an error.
Who can solve this for me please? Many thanks in advance.
