英文:
How can I highlight cells in a range that match equivalent cells in that same range on another sheet?
问题
我有一个Google表格上的两个选项卡（'Complete' 和 'Required'）。我希望使用条件格式设置，使得在 'Complete' 上范围 B2:AK10 中与 'Required' 上相同位置的单元格匹配的任何单元格都会被突出显示。
为了更多的上下文，所有单元格要么为空，要么包含一个整数。
我尝试了一些方法，比如 =match(indirect("Required!B2:AK10"))，但无法在整个范围内正常工作。
英文:
I've got two tabs on a Google Sheet ('Complete' and 'Required'). I was hoping to use conditional formatting so that any cell in the range B2:AK10 on 'Complete' which matches the cell in the same position on 'Required' is highlighted.
For addition context, all cells will either be empty of contain an integer.
I've tried a handful of things like =match(indirect("'Required'!B2:AK10")), but can't get anything to work properly across the full range.
答案1
得分: 0
应用范围：B2:K10
自定义公式：=B2=间接("必填！"&地址(行(),列()))
如果您希望在两侧匹配时跳过空单元格，则使用：=LEN(B2)*(B2=间接("必填！"&地址(行(),列())))
英文:
Within Conditional Formatting Rules try:
Apply to range: B2:K10
Custom Formula: =B2=indirect("Required!"&address(row(),column()))
If you wish to skip blank cells for a match on both sides then use: =len(B2)*(B2=indirect("Required!"&address(row(),column())))
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论