How Conditional Formatting is applied in Excel?

[Sunite]

How Conditional Formatting is applied in 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 100, the value in the respective cell will be bold. In figure below, the conditional formatting is applied to the cells C3 to CIO. When values in these cells are changed, Excel automatically updates the format of the cell's.

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

To apply the conditional formatting, follow the steps.

Select the cell's, you want to apply conditional formatting.

Choose Conditional Formatting command from the Format menu. The Conditional Formatting dialog box will appear as shown below.

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.

Click OK.

To delete the conditional formatting, follow these steps.

Select the cell's, you want to delete the conditional formatting.

Choose Conditional Formatting command from the Format menu. The Conditional Formatting dialog box will appear.

Click Delete button to remove a condition. You will be asked to choose which condition (1, 2 or 3) you want to remove.

Select the condition and click Ok button.