Compare and highlight

[rizmomin]

Hello:

Please refer to attached sheet.
i have 2 sets of data.
I need to compare the data and highlight.

First compare each cell in column W with each cell column L.
If match is found then compare the corresponding cell in column U with the value in column N.

Example:
W1 matches with L1 and U1 matches with N1 so do not highlight.
W2 matches with L7 and U2 does not match with N7 and hence highlight.

If value is different then highlight the cell in column U.

Let me Know if you have any questions.
Thanks.



Riz

[gak67]

in the conditional formatting for U2 put in this formula:

Please Login or Register  to view this content.

[rizmomin]

Hello gak67:

I have tried your formula and it does not work.
I have attached the sheet for your ref.

Thanks

Riz

[gak67]

You haven't set a format. Go to conditional formatting, manage rules, edit rule and click on the format button and choose how you want to highlight the cells.

[rizmomin]

Hi Gak67:

Thanks a lot...
Riz