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

To highlight a cell or row in Excel, we will be using Conditional Formatting. The Conditional Formatting feature easily spots, trends and patterns in your data using bars, colors, and Icons to ...

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.

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.

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.