Sort by formatting

M

MACXXXX

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 .
 
M

MACXXXX

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.
 
N

Niek Otten

Look at the second argument of the ColorIndex function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| 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 here:
| >
| > http://xldynamic.com/source/xld.ColourCounter.html
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > | 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 .
| >
| >
| >
 
D

David Biddulph

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

Jennifer Cali

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)
 
G

Gord Dibben

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
 
Top