小高分享（10）Excel条件格式02:26来自LearningYard学苑
分享兴趣，传播快乐，
增长见闻，留下美好！
亲爱的您，这里是LearningYard新学苑。
今天小编为你带来
【小高分享（10）Excel条件格式】
欢迎您的访问！
Share interests, spread happiness,
increase knowledge, and leave beautiful!
Dear you, this is LearningYard Academy.
Today, the editor brings you
【 Xiao Gao Share (10) Excel Conditional Format 】
一、基本介绍
Basic introduction
在用Excel处理数据时，会遇到需要对特定条件的数据进行突出显示的情况。这时候，条件格式就能派上大用场了！
When working with data in Excel, you will encounter situations where you need to highlight data with specific conditions. This is where conditional formatting comes in handy!
条件格式是一种根据设定的条件自动为单元格或单元格区域应用格式的功能。通过条件格式，我们可以轻松地将满足特定条件的数据以不同的颜色、字体或图案进行高亮显示，从而让数据更具说服力。
Conditional formatting is a feature that automatically applies formatting to a cell or region of cells based on a set condition. Conditional formatting makes it easy to highlight data that meets certain criteria in different colors, fonts, or patterns to make the data more convincing.
首先，我们需要选中需要应用条件格式的单元格或单元格区域。然后，点击“开始”选项卡中的“条件格式”按钮，选择“新建规则”。在新弹出的窗口中，我们可以根据需求选择不同的条件格式规则，例如“只为满足以下条件的单元格设置格式”或“使用公式确定要设置的单元格格式”。
First, we need to select the cell or region of cells to which we want to apply the conditional format. Then, click the "Conditional Format" button in the "Start" TAB and select "New Rule." In the new window that pops up, we can select different conditional formatting rules according to our needs, such as "Format only cells that meet the following conditions" or "Use a formula to determine the format of the cells to be set."
然后，我们就可以设置具体的条件了。例如，我们可以设置当单元格中的数值大于某个值时，单元格的颜色变为红色；当单元格中的数值小于某个值时，单元格的颜色变为绿色。此外，我们还可以设置多个条件，让Excel自动判断并应用相应的格式。
Then, we can set specific conditions. For example, we can set the color of the cell to red when the number in the cell is greater than a certain value; When the number in a cell is less than a certain value, the color of the cell changes to green. In addition, we can set multiple conditions so that Excel automatically determines and applies the appropriate format.
设置完成后，我们就可以看到符合条件的单元格已经被成功应用了条件格式。这时候，数据看起来会更加直观，分析起来也更加方便。
After the setup is complete, we can see that the conditional format has been successfully applied to the qualifying cells. At this point, the data will look more intuitive and easier to analyze.
条件格式不仅适用于数值数据，还可以应用于文本数据。我们可以设置当单元格中包含特定文本时，单元格的颜色变为蓝色；当单元格中包含其他文本时，单元格的颜色变为黄色。这样一来，我们就可以快速地找出需要关注的数据，提高工作效率。
Conditional formatting applies not only to numeric data, but also to text data. We can set the color of the cell to blue when it contains specific text; When the cell contains other text, the color of the cell changes to yellow. In this way, we can quickly identify the data we need to focus on and improve our productivity.
今天的分享就到这里了。
如果您对今天的文章有独特的想法，
欢迎给我们留言，
让我们相约明天，
祝您今天过得开心快乐！
That's it for today's sharing.
If you have a unique idea about today’s article,
Welcome to leave us a message,
Let us meet tomorrow,
I wish you a nice day today!
本文由learningyard新学苑原创，如有侵权，请联系我们。
部分内容参考于bilibili
翻译来源：百度翻译
文字&排版｜高杰
审核｜许江越