VBA Change colour of row if content in column matches array in another sheet

Hi Folks,

I have an array in Sheet 1 where column 4 contains client account numbers. The array is called 'EMX' and shows clients that get a discount off their transactions.

In sheet 2 I have a list of various client transactions. Column T holds the client account number for the transaction.

As part of a larger macro I run I would like it if the rows in Sheet 2 are yellow if the account number in column T in Sheet 2 appears in column 4 of the array EMX in Sheet 1. If the client account number in column T doesn't appear in the array then the row would remain white or have no fill.

Is anyone able to provide me with the VBA code that would enable this.

I hope I've explained this clearly enough.

As always, any help that you can give me would be greatly appreciated.

Hi Richard,

This code would form part of a larger macro. The data isn't there before the macro is run and the array is created as part of a macro. Users need to run this as a report and aren't too excel savvy.

Thanks