宏以突出显示列表中的名称 [英] Macro to highlight names in a list

问题描述

您好。  我正在尝试编写一个宏，该宏将通过我们在阿富汗收到的邮件列表，如果识别的姓氏（来自A列）与其对应的名字（来自B列）相匹配，则会突出显示行的背景。  我有大约
十个要搜索的名字。  任何帮助都会受到赞赏，因为具有讽刺意味的是，我没有太多时间来弄清楚这个节省时间的脚本。  列表的示例如下：

Hello.  I'm trying to write a macro that will go through a mail list we receive here in Afghanistan and highlight the background of a row if a recognized last name (from column A) matches its corresponding first name (from column B).  I have about ten names to search for.  Any help would be appreciated because, ironically, I don't have a lot of time to figure out this script that will save me time.  An example of the list follows:

推荐答案

按"匹配"，是指姓氏与名字匹配，或者你有一个十个名字的列表，你想搜索完整的匹配？

By "matches", do you mean that the surname matches the first name, or that you have a list of ten names which you want to search for full matches on?

这篇关于宏以突出显示列表中的名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！