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

Conditional formatting in Excel