Conditional formatting allows you to apply formatting to selected cells based on a particular criteria. In other words, if the value of the cells meets specific conditions you set, then the conditional formatting will be applied. Conditional formatting is a good way to call attention to specific values in your worksheet. For instance, if your product inventory falls below a certain level, you might add a green fill color, a yellow font color and bold formatting to cause the value to stand out from other cells.
When applying conditional formatting, you need to choose the comparison rule you want to apply and then enter your criteria for the comparison. You can choose from the following comparison rules:
- Greater Than
- Less Than
- Between
- Equal To
- Text that Contains
- A Date Occurring
- Duplicate Values
For more control, select More Rules from the Highlight Cell Rules menu. From here, you further customize your rules.
To Use Conditional Formatting
- Select the cell range you wish to format.
- Click the Home tab on the Ribbon.
- Click the Conditional Formatting button on the Home Ribbon and then point to Highlight Cell Rules.
- Click the comparison rule you want to apply to the selected data.
- Enter your criteria in the comparison rule dialog box.
- Select the desired formatting to be applied when the condition evaluates as true from the drop-down list (click Custom to specify your own formatting.)
- Click OK
Similar Posts:
- None Found
Comments on this entry are closed.