Software Training and Consulting
702 Fifth Avenue South, # 8
Kent, WA   98032-6026
Phone: 206-355-8304     Fax: 253-813-2452
Weekly Software Tip
Excel has a really helpful feature that many people either don't know how to use or aren't even aware it exists. It's called conditional formatting, and it allows you to tell Excel to format cells containing specific value ranges different from others.
This is very useful if say you're trying to look at monthly sales figures for a variety of items. You could tell Excel to shade any cell which has an increase of over 30% in yellow. This way, your attention will immediately be brought towards those items.
To use this handy feature do the following:
- Highlight the area where those figures will be located,
- Go to the Format menu and select Conditional Formatting,
- In the dialog box that appears, fill-in the condition(s) those figures must meet in order to be formatted differently,
- Click the Format option and set how you would like those cells formatted if the condition(s) are met.
Click here to visit our previous tips
|Home Page||Overview||Trainer Resumes|
|Satisfied Clients||Contact us||Service Request Form|
|Awards||Gifts & Resources||Apply for our Award|
|Product Reviews||Buyers Assistance|