How to highlight text values with conditional formatting
In this video, we show you how to create a conditional formatting rule highlights cells that contain specific text values.
Dave Bruns
How to use Icon sets with conditional formatting
In this video, we show you how to create a conditional formatting rule that uses icons to visualize numbers.
How to show duplicate values with conditional formatting
In this video, we show you how to create a conditional formatting rule highlights duplicate values in a set of data.
How to use color scales with conditional formatting
In this lecture, we show you how to create a conditional formatting rule that uses color scales to visualize numbers.
How to use a formula with conditional formatting
In this video, we show you how to create a conditional formatting rule that uses a formula to highlight cells that meet specific conditions not included in Excel's presets...
How to use data bars with conditional formatting
In this lecture, we show you how to create a conditional formatting rule that uses data bars to visualize numbers.
How to add a title and legend to a chart
In this video we show you how to add a title and a legend to a chart. We also show you how to move these elements around on a chart.
How to highlight above and below average values
In this lecture, we show you how to create a conditional formatting rule to highlight numbers that are above or below average in a set of data.
How to edit and add to chart data
In this video we show you how to keep a chart up to date with new data, and how to add new data to an existing chart.
How to highlight top and bottom values
In this lecture, we show you how to create a conditional formatting rule to highlight the top and bottom numbers in a set of data.