I have a matrix in my google sheet. I want to color a cell if its value is present in another array, meaning one cell of that array is identical. I am able to do it using conditional formatting and checking only one cell instead of the whole array, but this is not scalable to long arrays.
Here is a practical example:
This is my matrix:
This is the array Z29:Z36
And this is the desired output: