The aim of conditional formatting is to highlight data in the Microsoft Excel worksheet or spreadsheet so that it stands out from the rest of the excel data and provides a certain information.
Select the Excel cells to which you wish to apply 'formatting' based on some 'condition(s)'
Click on 'Format' in the menu bar
Select 'conditional formatting...'
Define the condition(s) to apply
Select the formatting style to apply if condition is true
Finish the process by clicking 'ok' as shown in the Excel training video
