In conditional formatting, the condition is not only the specific data, but also the result of returning the formula. We still take the results table as an example, so that the top 10 results are displayed in "Blue", so that the lower-than-average scores are displayed in "Red".
1. Select the range of cells in which the results are located, and execute the format → conditional format command to open the Conditional Formatting dialog box.
2. Press the Drop-down button on the right of the 1th box, and then in the Drop-down list that pops up, select the Formula option, and then enter the formula in the following box: =c2>=large (c$2:c$61,10).
Note: ① is set up once for the entire area, so we made a "relative reference" to C2 cells and C columns, and the scores were in lines 2nd to 61st, so we made an "absolute reference" to the area, where we added a "$" symbol before the corresponding position.
② The formula above means that the format is used when the value in the cell is greater than or equal to the 10th place (as determined by the LARGE (c$2:c$61,10) formula).
3, press the "Format" button, open the "Cell format" dialog box, in the "Font" tab, press the "color" to the right of the Drop-down button, in the subsequent pop-up palette, select the "Blue" option to determine return.
4, click the "Add" button, add a "conditional format", and then imitate the above operation, set a good below average "conditional format."
Note: The average division is calculated using the "AVERAGE (c$2:c$61)" formula.
5, after the completion of the set, determine return.
The animated display of the specific actions is as follows: