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

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

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.

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.

How to Get Microsoft Excel Cells to Shade Gray When Highlighted. If you liked finger painting as a child, you may love using your mouse to paint colors in Microsoft Excel. When you highlight cells ...

If you want duplicate values to stand out in an Excel spreadsheet, you can choose between two conditional formatting rules.

Click the merged cell you would like to split. Excel displays the "Merge & Center" button and highlights it. Click that button to split the cell back into its original cells.

Do you want to keep important labels and data in view as you scroll through your Excel worksheets? Here are the steps to freezing those columns and rows.