Hi All,
I'm having an issue with the best way to solve a request.
We have multiple projects each with a project manger and an assistant.
On our annual leave spreadsheet we would like it to highlight if the manager and the assistant for any specific project book leave at the same time.
I was thinking of having a control sheet with a list of projects in column A and column B & C having the project manger and assistant respectively.
Can a conditional formatting formula look at the list to see if two names are on the same row in any of the rows and highlight the cells for those two people if the annual leave sheet has conflicting leave for those two people?
Or is this going to require vba to get this working.
Trying to do this with conditional formatting if possible, but don't use it very often.
Any help on where to start with this would be much appreciated.
Thanks
I'm having an issue with the best way to solve a request.
We have multiple projects each with a project manger and an assistant.
On our annual leave spreadsheet we would like it to highlight if the manager and the assistant for any specific project book leave at the same time.
I was thinking of having a control sheet with a list of projects in column A and column B & C having the project manger and assistant respectively.
Can a conditional formatting formula look at the list to see if two names are on the same row in any of the rows and highlight the cells for those two people if the annual leave sheet has conflicting leave for those two people?
Or is this going to require vba to get this working.
Trying to do this with conditional formatting if possible, but don't use it very often.
Any help on where to start with this would be much appreciated.
Thanks