Is there anyway to do this? I have a sheet with times along the top and tasks
allocated underneath. I would like to be able to sort by the cell colour so I
can see who is on which task at any given time.

I have no idea how to do this, so any help at all would be appreciated.