Excel Staff Grade and Shift

Joined
Feb 23, 2018
Messages
67
Reaction score
24
So I have a group of staff some are classed as Grade 1 and can swap positions.

Is it possible to highlight the shifts/cells that the staff can be swapped on a rota.

So if 2 of them are on a D shift the D is highlighted....
 

Attachments

Back
Top