Conditional Formatting to highlight top three items
Uploaded time: October 28, 2021 Difficulty: Primary
Conditional Formatting to highlight top three items
Tips: you can turn on the volume by clicking
Graphic skills
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?