Set color for Excel formula return result

Source: Internet
Author: User

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:

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.