Dave, I think you misunderstood what op was asking. My understanding is that he/she wants to basically group all the rows that contain a particular color together since these are the rows that require changes to be made. This would allow user to make all necessary changes one row after another without having to jump around the workbook searching for the rows that are highlighted for change.
I don't think there is any built in functionality to do this but a simple macro could be created to add a value to a helper column if the row contains a particular color. After the macro is finished running you can just sort by the helper column value. If you need help with the macro post a sample workbook.
Rollin
I don't think there is any built in functionality to do this but a simple macro could be created to add a value to a helper column if the row contains a particular color. After the macro is finished running you can just sort by the helper column value. If you need help with the macro post a sample workbook.
Rollin
