gs conditional formatting - Conditionally color Google Spreadsheet cell if value matches different column in same row -

gs conditional formatting - Conditionally color Google Spreadsheet cell if value matches different column in same row -

i have google spreadsheet info values in first 10 columns (a through j) , 11th column (k) has reference value. pattern repeats 150 rows

so, first row, a1 through j1 info values , k1 reference value. , 25th row, a25 through j25 info values , k25 reference value.

now, info cell (cells within first 10 columns), value in cell matches value in corresponding reference cell (at column k in same row info cell), want alter background color of info cell.

so, info cell a1: if value in a1 == value in k1, alter background color of a1 and, info cell c23: if value in c23 == value in k23, alter background color of c23

i assume conditional formatting should able this, not figure out how. know how conditional formatting single cell, can't figure out how apply conditional formatting entire table (cells a1 through j150) @ once.

use next custom formula in conditional formatting:

=a1=$k1

and apply range a:j.

to exclude blank cells (and cells zero-length text strings), try:

=and(len(a1),a1=$k1)

google-spreadsheet gs-conditional-formatting