There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Excel 2016: Conditional Formatting in Depth

Video Introducing this tutorial


Using the exercise files

1. Conditional Formatting Based on Content or Formulas

Formatting based on Highlight Cell Rules options
Formatting based on unique or duplicate values
Formatting based on Top/Bottom Rules options
Formatting based on formulas
Editing rule descriptions

2. Conditional Formatting Using Data Bars, Color Scales, and Icon Sets

Using data bars to display length or volume
Using color scales to display relative differences
Using icon sets to provide strong visual emphasis

3. Specialized Conditional Formatting Uses

Applying conditional formatting across rows of data
Highlighting PivotTable results
Using data validation pick lists and conditional formatting for dynamic visual displays
Using conditional formatting to apply banded rows
Locating conditional formatting cells


Next steps