Conditional Formatting

Conditional Formatting, such a great tool. On the home tab of your #excel sheet. I have used it to highlight all the cells in my column that are over 85. You can use it to automatically highlight the top 10 values, or the lowest 5%, or cells that contain a certain word, or many other options. Give it a go next time you want a particular type of data to stand out.