WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android


Conditional formatting in Excel—Highlight

February 13, 2023

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.

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

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.

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.

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

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.