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

  • Rota Example Test.pdf
    90.5 KB · Views: 35
Ad

Advertisements


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
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
Excel Home made rota system- creating a time sheet in relation to demand 0

Top