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: 62

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 The logic hurts my head 5
Excel Is this possible?? 3
Excel 2 into 1 6
Counting multiple memberships 1
Access MS Access Staff Rota 2
Construct staff pay timesheet 1
Excel Home made rota system- creating a time sheet in relation to demand 0
Counting weekend shifts in a sheet 1

Top