How to create zebra stripes with conditional formatting
In this video, we'll look at how to use conditional formatting to shade every other row in a table. This is sometimes called "zebra striping"...
Dave Bruns
Conditional formatting with two variable inputs
In this video, we'll look at how to extend a conditional formatting formula so that so that it checks more than just one condition...
Conditional formatting with one variable input
In this video, we look at how to make conditional formatting variable, so that you can change how formatting is applied without editing a rule. This elegant technique helps you build killer spreadsheets that are fun to use.
...
How to apply conditional formatting with a formula
In this video, we'll look at how to use a simple formula to apply conditional formatting. Formulas allow you to create more flexible and powerful conditional formats...
How to highlight rows using multiple criteria
In this video, we'll look at how to use conditional formatting to highlight entire rows using multiple criteria...
How to test a conditional formatting formula
In this video, we'll look at an easy way to test a conditional formatting formula before you create the rule...
Conditional formatting based on a different cell
In this video, we'll look at how to apply conditional formatting to one cell based on values in another, using a formula...
How to use a slicer with multiple pivot tables
In this video, we look at how to configure a slicer to control more than one pivot table at once.
Pivot Table Example - Voting results
In this video, we look at how to use a pivot table to analyze voting data, including winning vote by percentage, and breakdown by age and gender.
Pivot Table Example - Instrument readings
In this video, we look at how to use a pivot table to analyze instrument measurements. This data consists of temperature readings taken in a green house over a period of days.