Excel4Business - Our Blog

Excel Tips and Tricks from our Experts

Excel Help - How to Highlight Cells in Excel 2013

In this video you’ll learn how to use Excel to automatically highlight relevant information in your table using conditional formatting. You’ll find this tool useful if you’d like the program to highlight and display cells that contain certain information. Some spreadsheets contain thousands of numbers and highlighting certain cells can make it easier to identify reasons for action. Excel can identify and highlight information such as outstanding payments or low profits. As well as making it easier to spot those entries visually, the program will then allow you to filter for the highlighted cells by color and address the problems.

Start by selecting the range of cells you want to format.

Click the Conditional Formatting dropdown menu.

Choose Highlight Cells Rules.

Choose your conditions and the color you would like to use to highlight the relevant cells.

Click OK.