Make your important data stand out
Highlight specific text in an entire column in Excel
By using a little color in your spreadsheet, you can make a cell or its contents stand out. This allows you to see the data you need at a glance. Here we show you how to highlight both cells and text in Microsoft Excel.
Although you can use conditional formatting in Excel to automatically highlight cells, you may have data that doesn’t change or you may just want to apply a single highlight. In just a few steps, you can apply highlights in Excel.
One of the easiest ways to highlight a cell or even a range of cells is to use a fill or background color.