Sorting By Colour??

[Guest]

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.

 

[Guest]

hi Shakey,

here is a link to Chip Person page with a module to sum based on the color,
maybe it can help you.

HTH
Regards from Brazil
Marcelo

"shakey1181" escreveu:

 

[Brainfire]

This worked a treat for me....

http://www.cpearson.com/excel/SortByColor.htm

 

[Bob Phillips]

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

--

HTH

Bob Phillips

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

 

[Guest]

Having tried a slightly more basic version, it doesn't even return the colour
index for

=colourindex(a1)

returns a #NAME? error...

any thoughts?

 

[Guest]

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)

 

[Nick Hodge]

Shakey

colourindex() will be a UDF (User Defined Function). This error shows Excel
is not recognising the UDF name, so you either have it in the wrong place or
you don't have it

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[Bob Phillips]

That formula is for counting the coloured cells, you seem to have got the
wrong part of the article.

--

HTH

Bob Phillips

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