I have a 10x10 grid, B2:K11
, in google sheets. Column A and row 1 contain a randomized list from the numbers 0-9. A12
and A13
will have the coordinates of a cell inside the grid and I need that to be highlighted. Currently in my conditional formatting, I have =ADDRESS(MATCH(A12, A2:A11, 0) 1,MATCH(A13, B1:K1,0) 1)=CELL("Address", B2)
(Applied to range B2:K11
), but this will only highlight B2
if the coordinates are the coordinates for B2...
I've tried changing the cell address in =CELL("Address", B2)
to other cells, and that still will only highlight B2 if the given cell is a match. Example I change the conditional formatting to =ADDRESS(MATCH(A12, A2:A11, 0) 1,MATCH(A13, B1:K1,0) 1)=CELL("Address", G6)
and set A12
and A13
to the header numbers that correspond the G6 and B2
is the cell that gets highlighted instead of G6. (See image below for example)