Conditional Formatting to highlight top three

Uploaded time: October 28, 2021 Difficulty: Primary

Conditional Formatting to highlight top three

Conditional Formatting to highlight top three

Tips: After starting to play, you can adjust the video clarity, click

Quality

Auto 720p

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.

_1.gif


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.

_2.gif


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.

_3.gif


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