Conditionally Sort in Excel

Deanna Reynolds May 14, 2007 Tips & Tutorials | 4 Comments

In Excel 2007, there’s a great NEW feature – Sorting and Filtering Data by Color! In previous versions of Excel, we’ve had access to three features in particular that help analyze data:

  • Sorting
  • Filtering
  • Conditionally Formatting

Each of these is a great feature all by itself in helping you to see visually data trends and hot spots. But, with the newly enhanced sorting and filtering in Excel 2007, now you can see trends and hot spots based on formatting, such as:

  • Cell color
  • Font color

And, because the conditional formatting feature has been greatly enhanced, Excel 2007 completely opens up the sorting and filtering views. You could spend an entire day just exploring these improvements.

Continue Reading...