Conditional Formatting in Excel 2010

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

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.

con1.jpg

Step 2

On Home tab click on Conditional Formatting.

con2.jpg

Step 3

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

con3.jpg

Step 4

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

con4.jpg

Step 5

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

con5.jpg

Step 6

Finally result will be displayed.

con6.jpg

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

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.