Excel conditional formatting automatically identifies a specific record

Source: Internet
Author: User

The conditional formatting feature of Excel is a powerful and convenient feature. The following describes one of the scenarios where you used the conditional formatting feature in your Excel process.

In an Excel worksheet, there are a number of records, how do you make Excel automatically identify records that meet certain criteria?

For example, the worksheet shown in the following illustration has more than one record requires that the row be highlighted when the field is no in the Finish column (in this case, the row is highlighted in red), so that the user is clear about the work that is not done, and the highlighted background color disappears automatically when yes.

Now start to achieve this effect, first look at the following figure:

① Select Columns A to E in the worksheet.

② Click menu "Format"--"conditional formatting."

③ in the Conditional Formatting dialog box, select the formula item in the Condition 1 drop-down box.

④ Enter the formula in the text box to the right of the formula box = $E 1 = "yes".

⑤ Click the Format button below and in the Format Cell dialog box, in the Pattern tab, select the color, which is red.

⑥ Click the OK button to close the Conditional Formatting dialog box. The effect at this point is the following figure:

At this point, when you change the cell data in e column to Yes, the red shading of the row disappears automatically, and if no, the line automatically adds red shading.

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.