Conditional Formatting allows us to see patterns and trends from data in a spreadsheet. 
Excel applies rules to the data in the cells and changes the formatting to help us visualise the data, making the worksheets easier to understand.
 Excel-ConditionalFormatting.mov
Excel-ConditionalFormatting.movConditional Formatting in Microsoft Excel