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.
Conditional Formatting in Microsoft Excel