Conditional formatting in Excel

The aim of conditional formatting in Excel is to highlight data in a worksheet or spreadsheet so that it stands out from the rest of the excel data and provides certain information. For example, you may want to highlight all employees whoe receive a salary of greater than or equal 2000000 per year. A teacher might want to know which students scored the highest marks in Math. A store owner might wish to know which products sell the best or which sales person contributed to the highest sales in a particular month or quarter. As you can see, formatting the Excel data based on some condition(s) or criteria is a great tool to extract information from raw data.

Microsoft Excel Training Videos

Conditional Formatting in Excel
The aim of conditional formatting in Excel is to highlight data in a worksheet or spreadsheet so that it stands out from the rest of the excel data and provides certain information. For example, you may want to highlight all employees whoe receive a salary of greater than or equal 2000000 per year. A teacher might want to know which students scored the highest marks in Math. A store owner might wish to know which products sell the best or which sales person contributed to the highest sales in a particular month or quarter. As you can see, formatting the Excel data based on some condition(s) or criteria is a great tool to extract information from raw data.


How to implement conditional formatting: 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

More resources on conditional formatting in Microsoft Excel
Conditional formatting in Excel

Conditional Formatting in Excel