About Microsoft Excel

Conditional Formatting in Microsoft Excel

Home Back Next




Condtional formatting in Microsoft Excel is the process by which you highlight specific data based on a condition. You can highlight students with marks greater than 90% in Maths. You can colour the salaries of employees who get a salary greater than or equal to 10000. You can highlight employees whose sales in a quarter are equal to or greater than a specified threshold. You can also highlight the duplicate entries in a range of Excel spreadsheet cells using conditional formatting. This feature of the Microsoft Office Excel suite is indeed very useful to analyze data. The training video above explains many of these aspects.
Note: The idea of placing the conditional formatting icon in the quick Access toolbar via the Microsoft Office Button using the Excel Options was to show how the process simplifies the use of a feature in the program.
Home Back Next