View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default 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