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 cell C2.
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?
Trending Tutorials
- 1. Quickly locate the name of the row and column where the cell is located
- 2. How can we change the spacing before and after a paragraph in WPS Writer
- 3. How to insert a check box in WPS Spreadsheet
- 4. How to create custom bullets in WPS Writer
- 5. How can we insert symbols in WPS Writer
- 6. Adjust shape fill in WPS Presentation