I have a table where cells have comma separated different numbers. I put 3 columns (A,B,C) and 8 rows. The actual table is larger.
matchproblem — imgbb.com
I am looking to find such a function; starting from the top of each column, if a value(s) in a cell matches with a value(s) in the cell down 4 rows in the same column, this cell (A1) is set to green color.
For example, in column A; if a number in A1 matches with a number in A5, A1 is set to green color. On this table, 90 in A1 and 90 in A5 is a match, so A1 is green color. Likewise, If a number in A2 matches with A6, A2 should set to green color automatically.
If there is no match, there should be no color change. The same goes for A3 and A7, A4 and A8, B1 and B5, B2 and B6, B3 and B7 etc.. down to the last cell with data in every column. I would really appreciate any help. Please let me know if anything is unclear. Thanks.
matchproblem — imgbb.com
I am looking to find such a function; starting from the top of each column, if a value(s) in a cell matches with a value(s) in the cell down 4 rows in the same column, this cell (A1) is set to green color.
For example, in column A; if a number in A1 matches with a number in A5, A1 is set to green color. On this table, 90 in A1 and 90 in A5 is a match, so A1 is green color. Likewise, If a number in A2 matches with A6, A2 should set to green color automatically.
If there is no match, there should be no color change. The same goes for A3 and A7, A4 and A8, B1 and B5, B2 and B6, B3 and B7 etc.. down to the last cell with data in every column. I would really appreciate any help. Please let me know if anything is unclear. Thanks.