|
|
|
Amazon.com
|
 |
|
|
|
|
|
|
|
Microsoft Excel 2007 Tutorial for beginners |
|
|
Welcome to MS Tips and Tricks |
Welcome to MS Tips and Tricks -
You are at the right place if you need tutorials for beginners - Online Microsoft Excel tutorials for beginners, covering the following categories
- Advanced Formulas, Pivot data, Charts, Databases, Customization, Table, Forms, etc.,
|
Microsoft Excel Tips and Tricks for beginners |
|
|
| |
| Formatting cells |
| |
| 11) You could set up specials conditions for automatic format. Select a cell and then, select the Conditional Formatting command from the
Styles Group. |
| |
|
| Illustration 11: Conditional Formatting. |
| |
| 12) Select the Highlight Cells Rules, then Greater than menu item. |
| |
|
| Illustration 12: Formatting rules. |
| |
| 13) Select the format condition and format style and press the OK button. |
| |
|
| Illustration 13: A new worksheet. |
| |
| 14) The cell will be formated when the condition is true. |
| |
|
| Illustration 14: Formatted cell. Click here to view larger image. |
| |
| 15) Select the Top / Bottom Rules, then Top 10 items menu item. |
| |
|
| Illustration 15: Formatting rules. |
| |
|
|
| |
|
|
|
|
|
|
|
|
|
