When a formatting applied to a particular cell or cells and it activates only when a condition is fulfilled then it is known as conditional formatting. For example a condition can be applied that if value in a cell becomes more than 200, all the values in that particular cell will become bold. This means that while doing conditional formatting, a condition or a criteria needs to be specified for formatting. If you also want to apply conditional formatting to your data in Excel sheet, follow these simple steps:
- Select a particular cell to which you want to apply conditional formatting.
- From the Format menu, select Conditional Formatting command. Conditional formatting dialog box will be appeared.
- Now specify the condition.
- To apply formatting, click Format button. Format Cells dialog box will appear on your computer screen. Here you will specify the format you want.
- If you want to specify another condition, click Add button. You can specify maximum three conditions.
- Now click OK.
If you don’t want to apply conditional formatting to cells and want to delete it, you can do so by following these steps:
- Select a particular cell from which you want to remove conditional formatting.
- From the Format menu, select Conditional Formatting command and you will see Conditional Formatting dialog box.
- To remove a condition, click Delete. You will be asked which of the three conditions you want to delete.
- After selecting condition, click OK button.