How to Highlight Values in Excel

To highlight cells with certain values in Excel, you use conditional formatting. This creates highlighted cells for certain content. In the example, you’ll learn how to highlight values in Excel easily.

Download the example here and follow along.

This example is of a grade book, and the goal is to highlight only the grades that are 90% and above.

Begin by making sure you have selected the range of cells with only the values you desire. In the Home tab up top, select “Conditional Formatting” and choose “New Rule”.

Highlighting Values in Excel

A dialog box will appear. Choose “Format only cells that contain” from this box.

In the boxes at the bottom of the dialog, there is the title “Format only cells with” and four drop down menus. Choose the following:

Cell value – between – 90 & 100.

Press the “Format” option and select a fill color for your highlight.

Highlighting Values in Excel

Press OK once you’ve finished.

The spreadsheet will now generate cells with a different color background based on what you have previously entered as the value range containing scores that are 90% and above.

Highlighting Values in Excel

Related Templates:

Leave a Reply

Your email address will not be published.

Time limit is exhausted. Please reload CAPTCHA.