From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Sort or filter data based on color font or cell color background

Sort or filter data based on color font or cell color background - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Sort or filter data based on color font or cell color background

“

- [Instructor] When you sort data in Excel nearly always it means moving rows up and down, and most of the time it means sorting by content, but we can also sort on the basis of cell color. For example, row four has a color background, yellow, row 12 is green, row 16 is orange, and so on. And we can sort by color font. Farther down on this list for example, row 37 there's a red font, perhaps some more a bit later too. We can sort on that basis. And in column J we've got some conditional formatting arrows. Now usually these are in sync with some kind of textural reference, and we'd probably sort on the basis of content. But here too we have an option, sorting by the icons that we see here. Let's imagine that we'll deal first with the colors. Before sorting any lists, recommendation is you have an orc with a list recently. Just to make sure click within it, press Control + A, that highlights the entire contiguous data,…

Contents