Conditional Formatting in Excel

Conditional Formatting in Excel:

How to use conditional formatting on raw data in excel.

Step 1.

Select a list from column on which you want to apply the conditional formatting.

Step 2.

Click on home tab in excel and select conditional formatting tab. Choose condition from drop down.

Step 3.

Put your condition accordingly.