Hi,
I have a spreadsheet which allows users to mark there attendence in the office on a particular day. However, there is a condition where if a certain person is coming in to the office, people sat next to them cannot come in same day and this applies multiple times. I have done conditional formatting so that the cells grey out for people who cannot come in when one of the person is attending, however is it possible to lock the grey cells as wwell so users cannot enter anything at all?
Any help much appreciated.
Thanks