A
A
AltMetal2020-10-12 10:22:41
Google Sheets
AltMetal, 2020-10-12 10:22:41

Create conditional formatting in Google Sheets on a list of values ​​from one column to another?

Good afternoon.
I ask you to help, because it does not reach whether it is possible to do this.
I want to paint cells in blue in a column, on sheet1, according to data from another column, from sheet2.

In more detail, you need to use the range of words from table 2, sheet2, to search for the same words in table 1, sheet1, and color it blue. Is it possible?

Example spreadsheet:
https://docs.google.com/spreadsheets/d/1LPC2rM4gAy...

Answer the question

In order to leave comments, you need to log in

2 answer(s)
V
Vladimir, 2020-10-12
@AltMetal

https://support.google.com/docs/answer/78413?co=GE...
5f8417061bd0e645300121.png

R
robprane, 2020-10-12
@robprane

=VLOOKUP(INDIRECT(ADDRESS(ROW();COLUMN()));'Sheet2'!A:A;1;0)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question