Back to Newsletter Archives
Back to The Software Pro Home
Smart & Easy Software Tips: Excel Conditional Formatting
Welcome to our many new subscribers who signed up through
http://www.SoftwarePro.com
(see bottom to leave "Smart & Easy Software Tips")
============================================================
Smart & Easy Software Tips, Tricks & Techniques
2006 - Issue 1, Volume 3
Publisher: Dawn Bjork Buzbee mailto:Dawn@SoftwarePro.com
The Software Pro(R), Certified Microsoft Office Expert
http://www.SoftwarePro.com
============================================================
In This Issue: Highlight Key Excel Data with Conditional Formatting
* What is Conditional Formatting in Microsoft Excel?
* How to Apply Conditional Formatting
* Modify or Delete Conditional Formatting
* Conditional Formatting Example
* Locate Cells With Conditional Formatting
============================================================
Missing the December Issue?
============================================================
Due to overzealous sp^m filters, some subscribers missed the last issue of 2005, "10 Ways to Organize and Plan for 2006."
Find these computer tips and newsletter at:
http://www.SoftwarePro.com/archives/december2005-16.htm
============================================================
What is Conditional Formatting?
============================================================
If 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.
For example, you can set conditional formatting so a cell turns blue if it contains a value higher than 75 and turns red if it contains a value lower than 50.
============================================================
How to Apply Conditional Formatting-The Basics
============================================================
1. Select the cells to be formatted.
2. Choose Format > Conditional Formatting...
3. Leave the first drop-down box set to Cell Value Is (the other option is 'Formula Is' which requires formula criteria.
4. In the second drop-down box, choose one of the operators such as 'greater than or equal to' or 'between'.
5. 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.
6. Click the Format button.
7. Choose any combination of Font, Border and/or Patterns.
8. Click OK.
9. To add another conditional format, click the Add button.
10. Repeat steps 3 to 8, choosing the criteria and format for the second condition. A third condition is also allowed.
11. Click OK to return to the worksheet and apply the formatting.
Conditional formatting is available in Microsoft Office Excel 2003, Microsoft Excel 2002, and Microsoft Excel 2000 (Office XP).
============================================================
Change or Remove Conditional Formatting
============================================================
1. Select the cells with the format you want to change or delete.
2. Choose Format > Conditional Formatting...
3. 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.
4. To remove conditional formatting, choose Delete and check which conditions you want to delete.
5. Choose OK twice to apply the changes.
============================================================
Conditional Formatting Example
============================================================
Learn more about Excel conditional formatting with this sample file:
http://www.SoftwarePro.com/howto/exl_cond_formatting.htm
============================================================
Find Cells With Conditional Formatting
============================================================
1. To find all cells with conditional formatting, click any cell. To find cells with conditional formatting settings identical to the settings of a specific cell, click the specific cell.
2. Pick Edit > Go To.
3. Click Special.
4. Click Conditional formats.
5. 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.
6. OK to return to the worksheet; cells with conditional formatting will be selected.
============================================================
Save time, highlight key data, and enhance your Excel worksheets with conditional formatting.
------------------------------------------------------------
Please pass this along to others who may appreciate it!
------------------------------------------------------------
For the latest additions to The Software Pro(R) website:
http://www.SoftwarePro.com/whatsnew.htm
Past newsletter issues are found at:
http://www.SoftwarePro.com/archives.htm
For Website or e-zine questions: mailto:Dawn@SoftwarePro.com
If you are receiving this issue as a forward, and want
your own subscription, visit
http://www.SoftwarePro.com/subscribe.htm
Privacy Policy - We hate receiving sp^m as much as
you do. Therefore, we never rent, trade, or sell
our email lists to anyone for any reason. You or
someone you know subscribed you to this e-zine list.
We never add names to our list until you voluntarily
subscribe.
(c) 2006 The Software Pro(R)
All rights reserved.
http://www.SoftwarePro.com
To Subscribe go to:
http://www.SoftwarePro.com/subscribe.htm
============================================================
Geek Speak Becomes People Friendly(tm)
Dawn Bjork Buzbee
The Software Pro(R)
11675 Bent Oaks Street, Suite 200
Parker, CO 80138 USA
(303) 699-6868, Fax (303) 766-0886
mailto:Dawn@SoftwarePro.com
http://www.SoftwarePro.com