functions with background colors

[Marcelo]

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

 

[Marcelo]

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


regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Marcelo" escreveu:

 

[Gord Dibben]

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

 

[Marcelo]

Thanks Gorden

Now it's working

best regards


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



"Gord Dibben" escreveu:

 

[Gord Dibben]

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


Gord