Monday, August 12, 2013

How to Use the Color of an Active Cell in Excel


1. Highlight the range of data you want to sort.
2. Select the Home tab at the top of the page, then click on 'Sort Filter' in the Editing group and then click 'Custom Sort...' to open the Sort dialog box.
3. Check the box labeled 'My data has headers' if you highlighted data header rows when selecting your data.
4. Choose the column by which you want to sort your data under 'Sort by' and then select Cell Color under 'Sort On.'
5. Choose the color by which you want to sort under 'Order.' All colors present in your data range, including 'No Cell Color,' will be available as options. Choose whether you want that data placed on top or on the bottom.
6. Add additional sorting levels by clicking 'Add level' and or 'Copy level,' if desired.
7. Click 'OK' to view your sorted data.

Blogger news