Sort by formatting
 

Is it possible to sort by cell color format or text color format? I tried to
gather info by CELL but it always returns G .

Sort by formatting
 

Look he

http://xldynamic.com/source/xld.ColourCounter.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"MACXXXX" wrote in message ...
| Is it possible to sort by cell color format or text color format? I tried to
| gather info by CELL but it always returns G .

Sort by formatting
 

Thanks for the code but it seems to only work with cell formatting- not text
formatting (font color) and I have a lot more of that.

"Niek Otten" wrote:

Look he

http://xldynamic.com/source/xld.ColourCounter.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"MACXXXX" wrote in message ...
| Is it possible to sort by cell color format or text color format? I tried to
| gather info by CELL but it always returns G .

Sort by formatting
 

Look at the second argument of the ColorIndex function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"MACXXXX" wrote in message ...
| Thanks for the code but it seems to only work with cell formatting- not text
| formatting (font color) and I have a lot more of that.
|
| "Niek Otten" wrote:
|
| Look he
|
| http://xldynamic.com/source/xld.ColourCounter.html
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "MACXXXX" wrote in message ...
| | Is it possible to sort by cell color format or text color format? I tried to
| | gather info by CELL but it always returns G .
|
|
|

Sort by formatting
 

What do *you* think the optional second argument of the ColorIndex function,
as described on that page, does?
--
David Biddulph

"MACXXXX" wrote in message
...
Thanks for the code but it seems to only work with cell formatting- not
text
formatting (font color) and I have a lot more of that.

"Niek Otten" wrote:

Look he

http://xldynamic.com/source/xld.ColourCounter.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"MACXXXX" wrote in message
...
| Is it possible to sort by cell color format or text color format? I
tried to
| gather info by CELL but it always returns G .

Sort by formatting
 

One follow-up. I can only seem to call the function if it's created in a
module within my current workbook. How can I create the function so it's
accessible each time I create a new workbook? I tried posting it in the
personal workbook, but if it's in there I can't call it (get the #NAME? error)

--
Thank you! - Jennifer


"Niek Otten" wrote:

Look he

http://xldynamic.com/source/xld.ColourCounter.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"MACXXXX" wrote in message ...
| Is it possible to sort by cell color format or text color format? I tried to
| gather info by CELL but it always returns G .

Sort by formatting
 

Jennifer

When using a UDF from Personal.xls you must preface it with the filename.

=Personal.xls!Function()

I prefer to place UDF's in an add-in.

No filename required

=Function() is sufficient.


Gord Dibben MS Excel MVP


On Fri, 24 Oct 2008 11:01:03 -0700, Jennifer Cali
wrote:

One follow-up. I can only seem to call the function if it's created in a
module within my current workbook. How can I create the function so it's
accessible each time I create a new workbook? I tried posting it in the
personal workbook, but if it's in there I can't call it (get the #NAME? error)