Conditional Formatting to highlight top three items

Uploaded time: October 28, 2021 Difficulty: Primary

Conditional Formatting to highlight top three items

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?