1。 点击 格式 > 条件格式，看截图：
2。 在 有条件的格式规则 窗格中，请执行以下操作：
（2。）在 格式化单元格 请从下拉列表中选择 自定义公式是 选项，然后输入这个公式： =匹配（C2，间接（“数据列表！A2：A”），0） 放入文本框中;
（3。）然后从中选择一种格式 格式化风格 如你所需。
注意：在上面的公式中： C2 是要突出显示的列数据的第一个单元格，以及 数据列表！A2：A 是工作表名称和列表单元格范围，其中包含要基于突出显示单元格的条件。
3。 并且所有基于列表单元格的匹配单元格都被一次突出显示，然后您应该单击 完成 按钮关闭 有条件的格式规则 如果需要的话。
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 4 months agoAmazing! Thank you! Worked perfectly!
To post as a guest, your comment is unpublished.· 8 months agoI found this really useful for referncing against one sheet, however is it possible to reference against all other sheets?
To post as a guest, your comment is unpublished.· 8 months agoHow about the opposite? I'd like to highlight a cell that doesn't match. How could I modify this formula to work for me?
To post as a guest, your comment is unpublished.· 9 months agoIs it possible to do this, but based on more than one column, and also highlight the whole row? I have a set of data that has Last Name and First Name columns as well as other data. I am then taking those names and arranging into groups on another sheet. I want to have a formula where once the particular person has been placed on the second sheet, they are 'done' and so their entire row (name + associated data for them) is highlighted in a color for 'done' on the original sheet.
To post as a guest, your comment is unpublished.· 1 years agoHI,
This is a very nice tutorial! how can I add a second condition to it? I'm seeking to match the cells and if the cels J:N in the correspondent row is not blank. I'm trying this, but it's not working: