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)

