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 50, the value in the respective cell will be italic. In figure below, the conditional formatting is applied to the cells C03 to CIO. When values in these cells are changed, Excel automatically updates the format of the cell's.
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.
See Also
microsoft windows technical support
malicious spyware removal
computer continually Restarts
Protect your PC
How to increase virtual memory in windows
No comments:
Post a Comment