Skillfully use Conditional Formatting to highlight performance

Uploaded time: October 22, 2021 Difficulty: Primary

Skillfully use Conditional Formatting to highlight  performance

Skillfully use Conditional Formatting to highlight performance

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

Quality

Auto 720p

Graphic skills

To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy. Take this table as an example. This is a sales performance table. Now we want to add a red flag to employees whose sales are greater than or equal to $950 while giving warnings to under-performers with sales less than $700. So how can we do that? We can use conditional formatting.

1. We can select the D2:D26 cell, then click the Conditional Formatting in the Home tab before choosing the Icon Sets option, and click the More Rules in the pop-up menu.

_1.gif


2. In the pop-up dialog box, select the red flag in the drop-down list of the first icon, select Number in the drop-down list of Type, and input 950 in Value. Then select No Cell Icon under the second icon, select Number under the drop-down list of Type, then input 700 in Value. Select a yellow exclamation mark under the third icon as a warning, and finally click OK.

_2.gif


At this time, a small red flag will be put in front of cells with a sales volume greater than or equal to 950, and a yellow exclamation mark in front of cells with a sales volume less than 700.

_3.gif


Did you get it?