Microsoft Excel’s RANK.EQ() function ranks a set of values, but in a busy sheet, the top-ranking items might get lost. You can combine RANK.EQ() with a conditional formatting rule to highlight ...

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

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.