Video Tutorials for Using Conditional Formatting in Excel 2007 & Excel 2010
(Excel Online Training)
|
|
 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)
|
|
|
|
More Excel videos are in the full course here.
|
|
|
Conditional formatting enables you to highlight cells with a certain 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 Excel 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?)
|
