Excel conditional formatting automatically identifies records that meet specific criteria

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:

Computer Tutorials

① 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.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

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.