Hi guys, 

Since Mynda built this dashboard maybes on for her?

The dashboard Mynda created I often use as a base to test a lot of things because its great however, one thing I have come across recently is, how can I note someone is (for example) working on site every Monday and Friday only, someone else is working every Wednesday and Friday etc etc you get the idea

The document I have attached is the dashboard I am using to test this on.. so, on the tab "Days on Site" you will see examples of 3 people that have set days they will be working on site, that's fine.. I have covered to end 2022. The issue comes when you click on the "Dashboard" tab, the conditional formatting kicks in as it should, but, what I would have expected is that because I am excluding days in the formula in the "Data" tab (Cell f12 gives the example) I would have seen green only on the days that I choose.. the rest white.

bringing this to life Samora is onsite week commencing 22/11/2021 on the 22nd and 26th so the Monday and Friday should be green but the 23rd, 24th and 25th would be white.

Hope you can help with what I am trying to achieve.. 

I have tried amending the conditional formatting but the green always seems to overwrite anything I do
The people that are noted will be constant until end of 22 (excluding new people or people leaving (or even people changing days) so if i have to remove all conditional formatting for a set range that will be fine.

Many thanks in advance

Lee