Conditional Formatting can be very useful when presenting data in a spreadsheet, or for allowing information to jump out to you easily.

In this video I go over the following uses of it:

- Formatting based on numerical value (greater than / less than / between)

- Formatting based on text contained

- Quick overview of Data Bars, Color Scales and Icon Sets

- How to use custom formula with Conditional Formatting to highlight entire row or other cells.

Make sure to download the most recent Master Workbook to follow along:

Loading more stuff…

Hmm…it looks like things are taking a while to load. Try again?

Loading videos…