Imagine a spreadsheet that automatically turns sales figures exceeding targets green, or instantly flags stocks that jump over 10% to yellow. Well, that’s the magic of conditional formatting.

Manually combing through spreadsheets with large datasets can be a massive headache at times. Luckily, conditional formatting exists in Microsoft Excel specifically for this reason.

Excel's conditional formatting lets you formats cells based on the value of those cells or their formulas. Learn the basics of this amazing feature.

Whether you're comparing a single list or several, Excel's conditional formatting can get the job done.

A row-by-row formatting rule is as easy to apply as a column-by-column in Microsoft Excel, but you might not get the results you thought you would.