What is the formula to find a matching number from the list in column D that is in another adjacent list and apply Conditional Formatting (say yellow) to that cell.
Example:
A B C D
24 408 72 [19]
284 91 55 [33]
36 12 40 [86]
…
Format matching # in this list…
A B C D
90 [19] 43 61
82 627 [33] 22
[86] 59 11 76
…
