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