Conditional formatting in Excel—Highlight

December 14, 2021

A free Office suite fully compatible with Microsoft Office

Free Download

We can use conditional formatting to highlight specific contents quickly. Here we take a sales table as an example.

Open your Spreadsheet, and click the Conditional Formatting drop-down button in the Home tab to get a menu.

We are going to talk about Highlight Cells Rules.

We have several more specific rules here, and we take Greater Than as an example.

We can use this rule to highlight the cells that satisfy the condition we set.

Conditional formatting in Excel2.png

1. Select the cell range for which you want to set rules. Click Greater Than to get a pop-up dialog.

Conditional formatting in Excel3.gif

2. Click the Select icon and select a cell as a condition, or enter the condition. Here we enter 150000, which means that the cells greater than 150000 will be highlighted.

Then select the highlight format that you want in the drop-down menu.

Conditional formatting in Excel4.gif

3. If you need more formats, you can click Custom Format to get another dialog. Here we set it Pattern as green for example. Then click OK. Then all the cells greater than 150000 are highlighted as green.

Conditional formatting in Excel5.gif

WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently.

Was this helpful?