excel 当前行突出显示_在Excel中突出显示当前月份的生日

excel 当前行突出显示

在Excel中突出显示当前月份的生日 (Highlight Current Month Birthdays in Excel)

August seems to be a very popular birthday month among my Excel friends. I won't mention any names here, because most of them are quite elderly, and the shock might upset them. 😉 Anyway, to all of them, and you, if you're celebrating this month -- happy birthday!

在我的Excel朋友中，八月似乎是一个非常受欢迎的生日月份。 在这里我不会提及任何名字，因为它们中的大多数都是年纪较大的，并且震惊可能会使他们不高兴。 😉无论如何，对于所有人，以及您，如果您正在庆祝本月的生日快乐！

生日清单 (The Birthday List)

If you're in charge of an employee list, and have to send birthday greetings, or hiring date anniversary congratulations, you can use Excel to help you keep track.

如果您负责员工名单，并且必须发送生日问候或雇用日期周年祝贺，则可以使用Excel来帮助您跟踪。

In the worksheet shown below, there are fake employee names and birth dates. In a separate column you could use the MONTH function to check which birth dates are in the current month.

在下面显示的工作表中，有假的员工姓名和生日。 在单独的列中，您可以使用MONTH函数检查当月的出生日期。

This formula compares the month of the date in column C, to the month of today's date. If the months are the same, the result is TRUE. =MONTH(C2)=MONTH(TODAY())

此公式将C列中日期的月份与今天日期的月份进行比较。 如果月份相同，则结果为TRUE。 = MONTH(C2)= MONTH(TODAY())

使用条件格式突出显示生日 (Highlight Birthdays with Conditional Formatting)

Instead of adding another column with formulas, you could use conditional formatting to highlight the current month's dates in column C. To highlight the dates:

您可以使用条件格式在C列中突出显示当前月份的日期，而不是在公式中添加另一列。要突出显示日期，请执行以下操作：

• Select all the dates in column C. In this example, cell C2 is the active cell.
  选择列C中的所有日期。在此示例中，单元格C2是活动单元格。
• On the Ribbon's Home tab, click Conditional Formatting
  在功能区的“主页”选项卡上，单击“条件格式”
• Click New Rule
  点击新规则
• In the New Formatting Rule dialog box, click on Use a Formula to Determine Which Cells to Format
  在“新格式设置规则”对话框中，单击“使用公式确定要格式化的单元格”

• =MONTH(C2)=MONTH(TODAY())

  = MONTH(C2)= MONTH(TODAY())

• Click the Format button, and select the formatting you want for the highlighted cell. In this example, the cells will be filled with light blue.
  单击格式按钮，然后为突出显示的单元格选择所需的格式。 在此示例中，单元格将用浅蓝色填充。

• Click OK to apply the conditional formatting.
  单击确定以应用条件格式。

发现生日 (Spot the Birthdays)

On the worksheet, all the birthdays from the current month are highlighted with the formatting that you selected. When you open the file at the start of each month, you'll quickly spot all the fake employees who are celebrating their birthdays.

在工作表上，以您选择的格式突出显示当月的所有生日。 在每个月初打开文件时，您会Swift发现所有正在庆祝生日的假员工。

翻译自: https://contexturesblog.com/archives/2010/08/06/highlight-current-month-birthdays-in-excel/

excel 当前行突出显示