In a data area, several cells are selected by highlighting in a different color. The example show cells that were manually selected, rather than using conditional formatting. However, if cells are shaded or have a different font color due to conditional formatting, this will work as well.
These can easily be sorted to the top of the list. Place your cursor in one of the cells that has the color to sort to the top. Right click.
From the pop-up menu, select sort > Selected cell color on top. This will sort based on the color.
I Teach Accounting Information Systems 