See http://xldynamic.com/source/xld.Colo...r.html#sorting

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"shakey1181" wrote in message
...
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.