grouping highlighted rows

[cox ng \(1\)]

I have a spreadsheet consisting of 100 rows, with 11 columns in each.
Different rows are highlighted via "conditional formatting" according to
number ranges in some of the cells. I wish to have the highlighted rows
move to the top of the list, that is if conditions are met to highlight a
row that row would move to the top of the spreadsheet joining all other
highlighted rows. I would want the highlighted rows to be sorted
alphabetically, followed by the non-highlighted rows sorted alphabetically.
Typically there are approximately 15 to 30 out of 100 rows that are
highlighted. Is there a formula or format to accomplish this? Thank you
for your consideration and time. Regards, Gary

 

[Dave Peterson]

I would use a helper cell in each of these rows that mimics the
format|conditional formatting rules.

Then you can sort by that column to group your data.

 

[cox ng \(1\)]

Because the highlighted rows change each day, assigning a helper cell to a
present highlighted cell would not prove practical. Thank you for your
time.

 

[Dave Peterson]

Well, working with conditional formatting is not for the faint of heart.

http://cpearson.com/excel/CFColors.htm
(from Chip Pearson)

Good luck,