Sorting By Colour??
 

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.

Sorting By Colour??
 

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:

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.

Sorting By Colour??
 

This worked a treat for me....

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


shakey1181 wrote:
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.

Sorting By Colour??
 

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.

Sorting By Colour??
 

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

=colourindex(a1)

returns a #NAME? error...

any thoughts?

"shakey1181" wrote:

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.

Sorting By Colour??
 

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.

Sorting By Colour??
 

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
HIS


"shakey1181" wrote in message
...
Having tried a slightly more basic version, it doesn't even return the
colour
index for

=colourindex(a1)

returns a #NAME? error...

any thoughts?

"shakey1181" wrote:

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.

Sorting By Colour??
 

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)

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