如果在Google表中的同一行的两个不同列中重复，请使用条件格式突出显示行
如果以前有人问过，我深表歉意，我尝试搜索，但找不到我想要的。我想使用条件格式在Google表中突出显示行，如果两个不同的行在E列中具有重复的数据，并且它们在F列中也具有重复的数据。 $ e1）＆gt; 1，countif（$ f：f，$ f1）＆gt; 1）似乎在大多数情况下工作，特别是如果有几行符合标准，但是问题如果E列中的任何位置以及F列中的任何地方都有重复，即使重复项在不同的行中，它仍在突出显示行。这是指向有问题行为的示例表的链接。在此示例表中，由于重复数据不在同一行中，因此不应重点介绍（如果它按照我打算的方式工作）。如果它以我打算的方式工作，则绝不应仅突出一行。
https://docs.google.com/spreadsheets/d/10lvijhfsvmkudnwcqb9gsieg-pjo87cqtpialob4yna/edit#gid=0
I apologize if this has been asked before, I tried searching but couldn't find exactly what I'm looking for. I want to highlight rows in Google Sheets using conditional formatting if two different rows have duplicate data in column E, and they also have duplicate data in column F. I'm currently using =AND(countif($E:E,$E1)>1,countif($F:F,$F1)>1) which seems to work most of the time, especially if there are several rows that meet the criteria, but the problem is it is still highlighting a row if there is a duplicate anywhere in column E, and anywhere in column F, even if the duplicates are in different rows. Here is a link to a sample sheet where the problematic behavior is shown. In this example sheet, no row should be highlighting right now (if it is working the way I intend), since the duplicate data is not in the same row. If it is working the way I intend, it should never highlight only one row.
https://docs.google.com/spreadsheets/d/10LvijhfsvMKUDNwCQB9GsiEG-pjO87cqtpialoB4YNA/edit#gid=0
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
尝试：
try: