Conditional Formatting in Excel 2010

In this article I am going in Conditional formatting in Excel 2010.
  • 2107

Conditional Formatting in Excel 2010

Conditional formatting is the properties in excel by which we can set the different type of formatting on lot of data with different types of condition. Example:- show the employee data with different format whose salary between 2000 to 5000.

How to create Conditional Formatting

Step 1

Open work sheet and select cell for we want to create Conditional formatting.


Step 2

On Home tab click on Conditional Formatting.


Step 3

Then a dropdown menu will be open. In this menu we can choose any format.


Step 4

Then a sub menu will be open. In sub menu we choose condition according to need.


Step 5

Than a condition dialog box will be open in this dialog box we enter the condition value according to need.


Step 6

Finally result will be displayed.


Ask Your Question 
Got a programming related question? You may want to post your question here


More Articles

© 2018 DotNetHeaven. All rights reserved.