Sort data by formatting

[Murtaza]

Is there any way to sort rows of data depending on their background color?

Like I have around 1000 mixed up rows of 5 colors (e.g. yellow, red, green,
violet, blue), and they are arranged in no specific order i.e first 2 yellow
rows, then 1 red, 4 blue, then again 3 yellow, and 3 blue ...so on.

I just want to arrange them in block of Colors like All Blue Rows, All
Yellow Rows etc.

Could it arrange using VBA or Excel?

 

[JulieD]

Hi

check out
http://www.cpearson.com/excel/SortByColor.htm
for some ideas

Cheers
JulieD

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.ColourCounter.html#sorting

--

HTH

RP
(remove nothere from the email address if mailing direct)