Tuesday, April 12, 2011

How to Sort by Cell Color


1. Click the first cell in the range of cells you want to sort. Drag down and across to highlight each of the cells that needed to be sorted by their color.
2. Navigate to the tab labeled 'Data.' Click the 'Sort' button at the left side of the 'Sort and Filter' grouping.
3. Click the 'Column' drop-down box underneath the 'Sort By' heading. Select the column in the range you want to sort.
4. Select the 'Sort On' drop-down menu and choose 'Cell Color.' Click the 'Order' drop-down menu and select the color you want to sort by, such as 'Green' or 'No Cell Color.'
5. Click the final drop-down menu and choose either 'On Top' or 'On Bottom' to specify where the sorted cells should be arranged. Click 'OK' to sort the range of cells by their color.

Blogger news