Excel Staff Grade and Shift

Feb 23, 2018
Reaction score
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....


  • Rota Example Test.pdf
    90.5 KB · Views: 60

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2 into 1 6
Excel The logic hurts my head 5
Excel Is this possible?? 3
Counting multiple memberships 1
Access MS Access Staff Rota 2
Can Vba workout if a selection is part of a group? 0
duplicate 5
Counting weekend shifts in a sheet 1