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