You’ve heard of data visualization, right?

Data visualization makes complex data more accessible and useful.

In a world overflowing with data, it’s more valuable than ever.

165 zip codes with some duplicates

Excel has a great tool for visualizing data called Conditional Formatting.

If you work with data in Excel (and who doesn’t these days?)

you’ll find it incredibly useful.

165 zip codes with some duplicates

Excel contains built-in rules to make both of these tasks easy.

Good luck finding names that appear only once with just your eyes!

Formulas allow you to create more powerful and flexible rules.

165 zip codes with some duplicates

This is a nice alternative to filtering because no data is hidden.

Video:How to build a search box with conditional formatting

165 zip codes with some duplicates

165 zip codes with some duplicates

Built-in conditional formatting rule for flagging duplicates

165 zip codes with duplicates clearly highlighted

Lots of names…which ones appear just once?

Built-in conditional formatting rule for flagging unique values

Unique names clearly highlighted

CF formula to count duplicates that appear at least 5 times

Names that appear at least 5 times clearly highlighted

Sales data by month and salesperson

Top 5 and bottom 5 CF rules

Top 5 values in green, bottom 5 values in red

Ready to highlight values greater than the input cell

CF formula compares values to named range “input”

All values greater than the input (800) highlighted

Only values greater than 900 highlighted

Order data…which orders are over 00?

CF formula to test only values in column E

Rows with orders over 00 in value are highlighted

CF rule to highlight rows based on owner

Tasks owned by Sue are highlighted

165 zip codes with some duplicates

165 zip codes with duplicates clearly highlighted

Lots of names…which ones appear just once?

Unique names clearly highlighted

Names that appear at least 5 times clearly highlighted

Sales data by month and salesperson

Top 5 and bottom 5 CF rules

Top 5 values in green, bottom 5 values in red

Ready to highlight values greater than the input cell

All values greater than the input (800) highlighted

Only values greater than 900 highlighted

Order data…which orders are over 00?

CF formula to test only values in column E

Rows with orders over 00 in value are highlighted

CF rule to highlight rows based on owner

Tasks owned by Sue are highlighted