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 ...

Susan Harkins shows you how to combine a function and conditional formatting to highlight weekends and holidays using Excel.

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 Highlight Intervals in Graphs in Excel. The interval between the gridlines in an Excel chart is typically blank, but you can highlight the intervals using an alternating pattern by changing ...

Conditional formatting highlights key information in a spreadsheet so it’s easy to see at a glance. This beginner’s guide gets you started using conditional formatting.

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.

Slicers provide an intuitive, user-friendly interface for filtering data in a spreadsheet. Here’s how to create slicers, format them, and use them to filter data in Excel.