Is there a way to compare each value of one table to another without using rules for every cell?
Table1 contains in each cell a number that a person choose, each person chooses 10 numbers.
Table2 starts empty and 5 numbers are inserted every week.
The result is to color the cells in Table1 that's value is equal to any of the cells in Table2 I've tried using an Equal To format but it only works it doesn't let compare one table to anothe.
