| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lost highlighting and font colors; background colors on web pages | Excel Discussion (Misc queries) | |||
| Alternate Background-colors | Excel Discussion (Misc queries) | |||
| In excel, importing from anouther sheet background colors will no. | Excel Worksheet Functions | |||
| excel problem with background colors in cells | Setting up and Configuration of Excel | |||
| Excel Cell Background Colors Disappeared | Excel Discussion (Misc queries) | |||
Linear Mode
