Forum Discussion
Solved
Conditional Colour Formatting for cells in a coloum depending on match in another sheet
Hello, I am looking for advice on how to conditionally colour format multiple cells in a colomn depending on if they match with entries in another sheet. I have two sheets where tags have bee...
Like this:
The rules are of type 'Use a formula to determine which cells to format', with formulas
=ISNUMBER(MATCH(A3, Sheet1!A:A, 0))
for blue, and
=ISNUMBER(MATCH(A3, Sheet2!A:A, 0))
for green. Replace Sheet1 and Sheet2 with the actual names of those sheets. If the names contain spaces or punctuation, enclose them in single quotes: 'Sheet 1'.
Like this:
The rules are of type 'Use a formula to determine which cells to format', with formulas
=ISNUMBER(MATCH(A3, Sheet1!A:A, 0))
for blue, and
=ISNUMBER(MATCH(A3, Sheet2!A:A, 0))
for green. Replace Sheet1 and Sheet2 with the actual names of those sheets. If the names contain spaces or punctuation, enclose them in single quotes: 'Sheet 1'.
- Thanks, Hans! This works perfectly well.
