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

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

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.

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

Learn how to highlight key data in Excel using conditional formatting, pivot tables & dynamic updates for actionable insights. Conditional formatting ...

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.

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

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.