Overlapping conditional formatting

Cross-posted at https://www.mrexcel.com/board/thread...tting.1224512/

Hello everyone,

I have a problem with our staff calendar, in Belgium (Dutch part and French part) the school holidays are different from the new school year, and since I work in a bilingual unit, both holidays have to be placed in the agenda, so it is now starting to look a bit like a coloring book.
Now I was wondering if it was possible to give overlapping conditional formats a different color or shading of the 2 colors used, just a matter of keeping it clean

As you can see in the picture below, the weekend gets a gray color, the Dutch one a green color and the French one a pink color.
Screen excel.png

I have attached the used file SitPers Staff 2023-2024.xlsm

Hopefully someone can help me, thanks in advance

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

I have added the link because you are a new member.

Note: There are already responses in the cross-linked thread.