Sorting or if statements reliant on formatting

A

Andy

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
 
J

Jim Cone

Information on a commercial alternative from yours truly ...
http://www.officeletter.com/blink/specialsort.html
--
Jim Cone
San Francisco, USA


"Andy" <[email protected]>
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
 
Top