Conditional formatting within Microsoft Excel can be used to segregate or sort data into groups. This helps you to gain a clearer picture of the story your data is telling. In our infographic below we have set up a simple 4 step process which shows how you can do this.
There are lots of options to choose form when utilising conditional formatting, from defining when the rule(s) should be applied through to how you display the data segments within your data. Have a play around with it and see the different ways you can present your data.