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

If Excel is not highlighting cells in the formula, enable 'Allow editing directly in cells' and 'Enable fill handle and cell drag-and-drop' in Excel options.

You can highlight cells with values above or below a specific number, between a numerical range, cells that match a specific value (number or text), or cells containing specific text.

How to highlight values Excel has a built-in conditional rule that highlights unique values. You don’t have to come up with a special formula—you just run though a few clicks.

The default active cell format in Microsoft Excel isn't all that easy to see, but you can use this easy-to-implement code solution to change that.