Learn how to highlight cells with negative values in Excel. Make negative numbers stand out in Red using Conditional or Custom Formatting.

How to use highlight cells rules With that out of the way, we’re going to begin with highlight cells rules. These can be found on the Home tab under Conditional Formatting > Highlight Cells Rules.

By using the Highlight Cells Rules, you can highlight duplicate cells in your Excel worksheet to avoid confusion and mistakes.

Use highlighting to delineate lines, which Excel calls rows, within the grid. In a single click, you can highlight an entire line or row, but this can get tedious when you need to highlight ...

How to use the built-in rule in Microsoft Excel Excel offers a few built-in conditional rules for formatting top and bottom values. They’re easy to use, but they’re not dynamic.

How to Highlight Every Other ID in Excel. When reading across a wide list of data, such as an account ledger or product description list, it is easy to confuse the rows.

Sparklines are in-cell charts in Microsoft Excel that are easy to create and extremely helpful, but they can be more insightful with just a few specific settings.

Microsoft Excel has more dataviz capabilities than you may realize. Find out how to make your data stand out with charts, PivotTables, sparklines, slicers and more.