How to apply Conditional Formatting in MS Excel?

 

 

 

A formatting that is applied to a cell or multiple cells and activated only if condition is met is called conditional formatting. For example, if a condition is applied in a selection that when any value in the selection is greater than 400, the value in the respective cell will be bold, under line or show with different color. For example, the conditional formatting is applied to the cells C4 to C12.  When values in these cells are changed, Excel automatically updated the format of the cells.

 

In conditional formatting, you have to specify a condition or criteria for formatting. The criteria are specified in the conditional formatting dialog box.

Perform the following steps to apply the conditional formatting: 

 

Select the cells, you want to apply the conditional formatting.

 

 

Choose conditional formatting command from the Format menu then conditional formatting dialog box will appear.

 

 

 

 

Here under Condition section, specify the condition.

 

 

 

Click Format button to apply formatting. Format cells dialog box will appear.  Specify the format you want.

 

 

Click Add button to specify another condition. You can specify up to three different conditions.