






| |
Dawn Bjork Buzbee
The Software Pro®
Microsoft Certified Application Specialist (MCAS) Instructor
Certified Microsoft Office Specialist Master Instructor
Certified Microsoft Office Expert
Certified Women's Business Enterprise (WBE)
(303) 699-6868
Dawn@SoftwarePro.com
|
|  | For Microsoft Office Excel 2003 and earlier versionsIf you have ever manually formatted Excel cells to highlight important data, then you need conditional formatting. If you want an automatic way to easily display key values and results, then you need conditional formatting. Conditional formatting in Microsoft Excel allows you to set rules for automatic cell formatting. If the rules (conditions) are met, then the formatting is applied. You can have up to 3 criteria in a cell. How to Apply Conditional Formatting - Select the cells to be formatted.
- Choose Format > Conditional Formatting...
- Leave the first drop-down box set to Cell Value Is (the other option is Formula Is which requires formula criteria.
- In the second drop-down box, choose one of the operators such as 'greater than or equal to' or 'between'.
- In the text box, type a number or a cell reference. For instance, you may want to format all cells with a value greater than the value in cell B5.
- Click the Format button.
- Choose any combination of Font, Border and/or Patterns.
- Click OK.
- To add another conditional format, click the Add button.
- Repeat steps 3 to 8, choosing the criteria and format for the second condition. A third condition is also allowed.
- Click OK to return to the worksheet and apply the formatting.
Change or Remove Conditional Formatting- Select the cells with the format that you want to change or delete.
- Choose Format > Conditional Formatting...
- To change, select Format for the condition you want to modify. To start from scratch, pick the Clear option and then pick your formatting choices.
- To remove conditional formatting, choose Delete and check which conditions you want to delete.
- Choose OK twice to apply the changes.
Find Cells That Have Conditional Formatting- To find all cells that have conditional formatting, click any cell. To find cells that have conditional formatting settings identical to the settings of a specific cell, click the specific cell.
- Pick Edit > Go To.
- Click Special.
- Click Conditional formats.
- Do one of the following:
To find cells with any conditional formatting, click All below Data validation. To find cells with identical conditional formats, click Same below Data validation. - OK to return to the worksheet; cells with conditional formatting will be selected.

|  | 
You can add up to 3 different rules for conditional formatting in Microsoft Excel. |
| Choose Edit > Go To > Special to move to specific locations or values within a worksheet. |
|
Tips, Tricks, Secrets
that you need to know now!
|
|