i am using the formula in the link you posted bob, and still struggling. I am
using the below and it is not returning the correct result...

=SUMPRODUCT(--(ColorIndex(A1:A100)=3),A1:A100)


"Bob Phillips" wrote:

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.