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

To select and delete text, click any of the cells in the chosen column, for instance, column A1. If you select the cell in A1, Press the Ctrl +Shift + Page up key.

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.