12. Finding and highlighting cells according to their content (color codes)

skjermbilde-2016-12-01-11-03-02When you start handling tens or hundreds of cells and need to know, for example, where the cells with the 10 highest and 10 lowest values are located, you clearly hope that there exists a button somewhere in the ribbon that can pick and mark those cells for you. Well… that button exists, it is called Conditional Formatting and may be found in the Styles section of the Home ribbon (see picture to the right). As you see in the menu, you may use pre-existing rules to highlight your data (such as highlighting the cells containing values greater than or equal to the value of your choice or to the average), rules to reveal duplicates, rules to highlight the top 5 or top 10 values in the table… You may also use color scales to give the lower values a specific color while the higher values are in a different color…




skjermbilde-2016-12-01-10-23-48Now, cells which have been highlighted using this conditional formatting can be sorted by color codes. As explained above, use the Custom sort... option in the Sort&Filter function (see picture to the right) to sort your table using cell color or even font color as a parameter. Not only your values of interest will be visible, but also cleanly arranged.

  Fant du det du lette etter? Did you find this helpful?
[Average: 4]