Computertim Technologies - free computer training, tips, and support

Home Articles Help Shop Business Education

> Articles

Microsoft Windows
Microsoft Word
Microsoft Outlook
Microsoft Excel
Microsoft PowerPoint
Microsoft FrontPage
Palm OS
General Articles

Microsoft Excel

Print article

 E-mail this page

Apply Conditional Formatting

Reader rating: 4 out of 10


Microsoft Excel can apply formatting when your data in the worksheet reaches certain conditions.  Therefore, you can quickly locate important data in a worksheet.

Apply Conditional Formatting

1.  Open Microsoft Excel and open the document you would like to use Conditional Formatting on.

2.  Highlight the cells that contain the data you want Excel to format when it meets a certain condition.

3.  Click the Format menu and click Conditional Formatting from the menu that appears.

4.  Click the drop-down menu that currently has "between" in it and select an operator for this condition.

5.  Click the first text box (from the left) and type the value you want to use for the condition.

6.  If you selected between or not between in step 4, click the second text box and type the second value.

7.  Click format to tell Excel how you want to format the data when the condition is met.

8.  The screen now displayed is a basic screen you see throughout Office 2000 programs.  You can select a font to use along with a color, style, and even borders on the borders tab.  You can also have the cell with the data have a different pattern by changing options on the Patterns tab.

9.  When finished, click the OK button.

10.  Click OK on the Conditional Formatting dialog box as well.

11.  Now, the data in the cells you selected will change to the Formatting once they meet the conditions you specified.

Remove Conditional Formatting

1.  Perform steps 1-3 in the above directions.

2.  In the Conditional Formatting dialog box, click the Delete... button.  

Rate this article:

Poor   1 - 2 - 3 - 4 - 5 - 6 - 7 - 8 - 9 - 10   Excellent

Books on Microsoft Excel

Featured articles

Choosing a Cell Phone and Rate Plan - General Articles

Stopping Unwanted E-mail - General Articles

Learn about Cookies - Microsoft Windows

HotSync Timeout Errors - Palm OS

Also from Computertim Technologies

Thoughts on Internet Advertising - an interactive opinion essay by Tim Rooney.

Post your opinions on technology and get free computer help in the forums.

Tired of AOL? Try Juno for half the price of AOL.

Shop for the best deals online at our shopping site.

Home  |  Articles  |  Help  |  Shop  |  Business  |  Education  |  Contact Us

Privacy Policy

Copyright 2003 Computertim Technologies.  All rights reserved.