functions with background colors
 

hello everybody,

I have been tried to use a chip pearson code
http://www.cpearson.com/excel/SortByColor.htm

but it doesn't work on my 2003 excel.
=colorindexofcell(A2;false.true)

It is returning #NAME?

How could help me to solve it?

regards from Brazil
Thanks in advance for your feedback.
Marcelo

functions with background colors
 

the correct fuction is
=colorindexofcell(a2,false,true)


regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Marcelo" escreveu:

hello everybody,

I have been tried to use a chip pearson code
http://www.cpearson.com/excel/SortByColor.htm

but it doesn't work on my 2003 excel.
=colorindexofcell(A2;false.true)

It is returning #NAME?

How could help me to solve it?

regards from Brazil
Thanks in advance for your feedback.
Marcelo

functions with background colors
 

Where have you pasted the code?

Try =Workbook.xls!colorindexofcell(A2;false.true)

Where Workbook.xls is the name of the workbook where you installed the code.


Gord Dibben MS Excel MVP


On Mon, 10 Dec 2007 10:39:21 -0800, Marcelo
wrote:

hello everybody,

I have been tried to use a chip pearson code
http://www.cpearson.com/excel/SortByColor.htm

but it doesn't work on my 2003 excel.
=colorindexofcell(A2;false.true)

It is returning #NAME?

How could help me to solve it?

regards from Brazil
Thanks in advance for your feedback.
Marcelo

functions with background colors
 

Thanks Gorden

Now it's working

best regards


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Gord Dibben" escreveu:

Where have you pasted the code?

Try =Workbook.xls!colorindexofcell(A2;false.true)

Where Workbook.xls is the name of the workbook where you installed the code.


Gord Dibben MS Excel MVP


On Mon, 10 Dec 2007 10:39:21 -0800, Marcelo
wrote:

hello everybody,

I have been tried to use a chip pearson code
http://www.cpearson.com/excel/SortByColor.htm

but it doesn't work on my 2003 excel.
=colorindexofcell(A2;false.true)

It is returning #NAME?

How could help me to solve it?

regards from Brazil
Thanks in advance for your feedback.
Marcelo

functions with background colors
 

I just assumed you used ; and . as default separators.


Gord

On Mon, 10 Dec 2007 10:48:01 -0800, Marcelo
wrote:

the correct fuction is
=colorindexofcell(a2,false,true)


regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Marcelo" escreveu:

hello everybody,

I have been tried to use a chip pearson code
http://www.cpearson.com/excel/SortByColor.htm

but it doesn't work on my 2003 excel.
=colorindexofcell(A2;false.true)

It is returning #NAME?

How could help me to solve it?

regards from Brazil
Thanks in advance for your feedback.
Marcelo