Like and see, form a habit; Read a hundred times, its meaning from see. Wechat search [Yixin Excel] to pay attention to this different we-media person. In this paper, making github.com/hugogoos/Ex… Has been included, including Excel system learning guide series of articles, as well as a variety of Excel materials.
Conditional formatting means that when a cell meets certain conditions, it will automatically set some eye-catching prompts, such as font, color, border and so on. This is also a very practical skill, today xiaobian here to share with you the magic of conditional formatting. Conditional Formatting Conditional Formatting is located under the Styles command group under the Start TAB.
1. Automatically mark those who meet performance standards
For a company with hundreds of thousands of employees, what kind of performance sheets should you give the boss that the boss wants? If you’re the boss, you want to see those people deliver.
Let’s take the picture above as an example. Let’s mark in red the background of the record where the performance met that is, the actual sales exceeded the sales target.
Let’s take a look at the specific operation steps:
① Select A3:D10.
② Click “Conditional Format” under “Style” command group under “Start” TAB and select “New Rule”;
③ Select “Use the formula to determine the cell to format” as the rule type;
④ Enter = D4>D4>D4>C4 in the format for setting values that conform to the formula.
⑤ Set the filling color of the format to red in the preview;
⑥ Click OK to complete the operation.
Let’s look at the dynamic effect:
2. Automatically mark the name according to the surname
As shown above, when we want to enter a last name in cell F6, the name background of the last name is automatically marked red in the left name field.
Here is a step by step implementation of this function:
① Select area A4:D10 first;
② Then click “Conditional Format” under “Style” command group under “Start” TAB and select “New Rule”;
③ Then select the rule type as “Use the formula to determine the cells to be formatted”;
COUNTIF(A4, fff6&” *”)>0; COUNTIF(A4, fff6&” *”)>0;
⑤ Then set the fill color of the format to red in the preview and click OK to finish.
Specific demonstration is as follows:
Function analysis
COUNTIF function functions and syntax.
Main functions: Is a statistical function that counts the number of cells that meet a certain condition.
Syntax: =COUNTIF(which areas to check, what to look for).
COUNTIF(D4:D10,” liu *”) =COUNTIF(D4:D10,” liu *”) =COUNTIF(D4:D10,” liu “)
Today’s sharing ends here, but the road of learning has just begun, I hope we can keep moving forward on the road of learning, perseverance.
If you are interested in the feature, you can tell xiaobian oh, xiaobian will write a corresponding article for you. Of course, it’s first come, first written. I will make a schedule and try to meet everyone’s needs. So if the next article is not what you want, please don’t worry, it may be the next one. Let me know what you want to learn.
This article continues to update, you can search wechat “yixin Excel” first time to read, this article GitHub github.com/hugogoos/Ex… Excel System Learning Guide series, welcome Star.
