﻿ Conditional formatting in Excel 2007: Learn with Examples
MS Office Training
 Excel Tutorial Excel Formulas Microsoft Word Training

Typing Training
 Typing Games For Kids Typing Tutorial Typing Test

Math Games
 Math Games Place Value Probability

Spelling & Vocabulary
 Spelling Games Crossword Puzzles Word Search

Grammar & Writing
 Learn English Grammar Creative Writing Course

Life Skills for Kids
 Good Study Habits Goal Setting Financial Literacy

Relaxing Mindfulness

Website Info
 Excel Basics Formulas & Functions Special Features Format Cells Sum, Average, Countif Functions Excel Charts (Graphs) Worksheets Quick Functions Excel Sort Edit Cells The IF Statement Excel Filter Rows and Columns VLOOKUP Function Conditional Formatting Find and Replace Sumif Function Pivot Table The Fill Handle Excel Formulas Create a Drop Down List Excel Keyboard Shortcuts First Aid

# Video Tutorials for Using Conditional Formatting in Excel 2007 & Excel 2010

Easy conditional formatting tutorial videos teaching you all about this special feature - what it is and the various ways you can use it. All examples are accompanied by relevant spreadsheets, enabling you to immediately self practice the material. The last video teaches the special case of using it with a formula to format an entire row.
The basics of conditional formatting
Three simple examples
Removing (Clearing) the Conditional Formatting
Removing only one rule of Conditional Formatting
Copy Conditional Formatting
Highlight the highest and lowest values
with Conditional Formatting
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 enable cells to appear with certain background colors, depending on their values.

For example, all positive values can appear with a green background, while negative values with red.
Actually, not only background colors can be applied (though they are the most popularly used), but many other styling effects too, such as font size, font color, bold, italic or underline, adding borders etc.

The rules you apply “stick” to the cells, so their format changes dynamically when their values change.
In the above example, if a cell had a positive value (and showed a green background) and then its value changed to negative, it will automatically become red.

More examples for Excel conditional formatting can be:
- Highlighting all values greater than \$2000.
- Highlighting 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)
- Highlighting all duplicate values in a certain range (don’t you wish to easily find and locate annoying repeating values in a list?)