Excel Basics Calculations Special Features
Format Cells Sum, Average, Countif Functions Charts (Graphs)
Worksheets Quick Functions Sort Data
Edit Cells The IF Statement Filter Data
Rows and Columns VLOOKUP Function Conditional Formatting
Find and Replace Excel Formulas Pivot Table
The Fill Handle First Aid
Excel Training
Microsoft Word Training
About
Ask your question here
Guestbook
Excel Course CD

Video Tutorials for Using Conditional Formatting in Excel 2007
The basics of conditional formatting Applying simple conditional formatting
Three simple examples
Removing (Clearing) the Conditional Formatting Removing and clearing the conditional formatting
Removing only one rule of Conditional Formatting Removing one rule of conditional formatting
Copy Conditional Formatting Copying conditional formatting using the format painter
Highlight the highest and lowest values
       with Conditional Formatting 		How to apply conditional formatting for the highest value
Finding duplicate values (or unique values)
       with Conditional Formatting
Highlight the entire row based upon a cell value
       with Conditional Formatting (using a formula)

Conditional formatting enables you to highlight cells with a curtain color, depending on the cell’s value.

For example, highlighting positive values with green background color, and negative values with red.
(actually not only the color can be set, but every aspect of cell formatting can be applied this way - font style, size, bold, underline etc.)

The conditional formatting “sticks” to the cell, and changes dynamically depending on the cell’s value. In the above example, if a cell had a positive value (hence was formatted with green) and then it changed its value to negative, it will automatically become red.

More examples for conditional formatting:
- Highlight all values greater than $2000.
- Highlight only the cell containing the highest value among a group of cells. (this could be relevant when you wish to highlight the highest score in the class, or highlight the highest salary in a company)
- Highlight all duplicate values in a curtain range (don’t you wish to easily find and locate annoying duplicate values in a list?)



Website Statistics