software

Hi there.

If I have rows formatted differently with fills/fonts etc, is there anyway
to sort the rows by the formatting? Alternatively to provide an if statement
that will provide a flag dependent on the formatting...

Just have a workbook circa 50K rows that someone has manually formatted and
I need to organise by the formatting!!!
Thanks

See these two sites

www.xldynamic.com/source/xld.ColourCounter.html

www.cpearson.com/excel/SortByColor.htm
quot;Andyquot; wrote:

gt; Hi there.
gt;
gt; If I have rows formatted differently with fills/fonts etc, is there anyway
gt; to sort the rows by the formatting? Alternatively to provide an if statement
gt; that will provide a flag dependent on the formatting...
gt;
gt; Just have a workbook circa 50K rows that someone has manually formatted and
gt; I need to organise by the formatting!!!
gt; Thanks

Information on a commercial alternative from yours truly ...
www.officeletter.com/blink/specialsort.html
--
Jim Cone
San Francisco, USAquot;Andyquot; gt;
wrote in message
...
Hi there.
If I have rows formatted differently with fills/fonts etc, is there anyway
to sort the rows by the formatting? Alternatively to provide an if statement
that will provide a flag dependent on the formatting...
Just have a workbook circa 50K rows that someone has manually formatted and
I need to organise by the formatting!!!
Thanks