Conditional formatting is a helpful way to quickly, easily and accurately pinpoint specific data in Excel by automatically coloring the cells containing data or data ranges you specify.

You can highlight cells containing data that is greater than, less than, between, equal to, cells that contain a specific word, phrase or number, cells that have a date occurring between a specific range and duplicate and unique data. You can also highlight top & bottom counts or percentages, above/below average and you can fully customize the fill & text colors and font.

Best of all, once you’ve used conditional formatting, you can also sort by cell color, so if you format by top and bottom 10 using different colors, you can sort and have those colors appear wherever you choose in the column.

Don’t forget to subscribe to my channel for more tutorials!

Advertisements