CODEWITHSUNDEEP
google-sheetsspreadsheet
TechCare99
TechCare99

Reputation: 1831

Conditional formatting cells in range if the cell value exist in a different column

In Google spreadsheet, we have column A which is an input list. Other columns from B to G are filled list. Filled list cells should highlight when cell value matches with input list. The problem is I can not use MATCH as matching is with the range not column or row.

Here is the expected result. expected result

Upvotes: 0

Views: 3347

Answers (1)

Gangula
Gangula

Reputation: 7264

You definetely can use Match. But you need to use it with ISERROR & NOT formula.
You need apply the following Conditional formatting to the entire range starting from B1.

=NOT(ISERROR(MATCH(B1,$A:$A,0)))

Note: if you copy the formula exactly, you need to apply it to the Range starting from B! For it work.

Upvotes: 2

Related Questions