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 to highlight top three items

Uploaded time: October 28, 2021 Difficulty Beginner

Conditional Formatting to highlight top three items

Conditional Formatting to highlight top three items

The Conditional Formatting function can format the cells fulfiling specific conditions. With this function, we can quickly compare data in a worksheet.

The worksheet in this example records the performance of staff. What if we want to highlight the Top Three performances? When there is a large amount of data, Conditional Formatting can quickly filter the first three maximums.

1. Select cellC2.

2. Then, press Ctrl + Shift + DOWN (↓) for quick selection from cell C2 to C26 (C2:C26).

3. Go to Home and click the Conditional Formatting drop-down button.

4. Choose Top/Bottom Rules and then Top 10 Items.

5. Change the number '10' to '3' in the pop-up window, and click the drop-down button. Here we can choose from the default formats we can also select Custom Format for more types. If we choose Custom Format, we will see a pop-up dialog. In this example, we choose Font, adopting the style 'Italic' and the color 'white'. (We can also set the border and the filled color.)

6. Finally, click OK to highlight the Top Three with the format we just set.

When two cells are filled with the same data, '95', for example, it means the two students get the same ranking. On such occasions, Conditional Formatting will highlight the two cells. Therefore, it will fill four cells with colors.

That's all for today's tutorial on Conditional Formatting. Did you get it?

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