Conditional Formating

Conditional formatting in Excel enables you to highlight cells with a certain color, depending on the cell's value. We mostly used the Highlight Cell Rules which helps you to understand the file easier. To highlight cell here are the following steps.

   Highlight Cells Rules

1.   Select the range A1:A10.

2.   On the Home tab, click Conditional Formatting, Highlight Cells Rules, and Greater Than...

3.   Enter the value 80 and select a formatting style.

4.   Click OK.

Result. Excel highlights the cells that are greater than 80.

5.   Change the value of cell A1 to 81.

Result. Excel changes the format of cell A1 automatically.

There are more rules in conditional Formatting like Top/Bottom Rules, Data Bars, Color Scales, and Icon Sets. All of this is really awesome and fun to use but the most exciting one is Creating New Rule! I tried making my own rule and I can say that I enjoyed it