1。 點擊 格式 > 條件格式，看截圖：
2。 在 條件格式規則 窗格中，請執行以下操作：
（2。）在 格式化單元格if 請從下拉列表中選擇 自定義公式是 選項，然後輸入這個公式： =匹配（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.· 6 months agoAmazing! Thank you! Worked perfectly!
To post as a guest, your comment is unpublished.· 10 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.· 10 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.· 11 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: