CF to highlight all matching values in two tables if a cell in another table has any value
Please, I need help with this.
This is a bit confusing to explain, so please forgive me if I make no sense or if the title for this post is off.
If a cell in table T1 has any value (anything – and x, y, a word, or a number, etc.), then highlight in table T3 the values found in table T2 in the corresponding entire row.
In other words, if cell F22 has a value (in this case an X, but it can be any value as long as is not empty), then the values in table T2, in the entire row 22 (numbers 1 and 2 in this example) need to be highlighted in table T3 (the number 1 and 2 will be highlighted in table T3).
NOTES:
- The values to be matched in T2 and T3 are alphanumeric, but in this example I only used numbers to make it simple.
- Only table T3 needs to have highlights for the matching values.
- Table T2 values for the entire row (for example H21:P21) need to be considered when matching them with table T3 (R21:R29). In this example, only column “H” and “I” have values but there could be more values all the way to column P.
- Table T2 values go from left to right (row) and the values in table T3 go from top to bottom (column) but I suppose they could also be repositioned from left to right (I think it makes no difference as long as the matched numbers get highlighted in the table T3 range).
- Table T1 could have more than one cell with values, therefore, even if the numbers repeat they must be highlighted in table T3 (same color or different color, doesn’t matter).
- If table T1 has no values, then nothing gets highlighted (obviously).
Please see attached file. I made a duplicate to the right to illustrate manually what is needed.
Bookmarks