Holidays management in excel

Hi everyone! I'm currently trying to format a holidays tracker and could do with some help.

It currently looks like a calendar day by day with AM and PM columns. When each person is on holiday we merge cells (not ideal!) and put the person's name in which conditional formats text to white and background to whatever colour.

We want to be able to see per project which people are on holiday, so you type the project reference in a box and it hides the holidays of anyone who's not on that project.

I've added a column of staff and listed by project allocations, then done a partial match so all the allocations can be seen. This produces "y" if they're on the project or "n" if not. I want to use the result of that to say if this person is not on the project we're looking at, fill the background of any holidays that person has booked in white and override the existing conditional formatting.

I've tried vlookups, xlookups, match, index, ifs and ands and I'm sure that some combination of these is correct, I just can't seem to figure it out 😂 any help would be greatly appreciated!