Match a value and check if it appears within a table and shade if it appears

Hi

I am busy learning and applying

I have a some information that I would like to check in a table if it appears and if it does, the table cell should be shaded yellow.

After all 60 values have been checked, It will be nice ifa list can be made off the rows in the table that are un shaded.
i

In H2 it looks at the value in F2 and checks the table from m2 to u17 and if the value of the cell matches in the table, it must shade the table cell yellw.

It must check from f2 to f62 and shade all matches.

After matching, it must list the rows within the table that is not shaded.


Thank you in anticipation for the help and advice

Regards

raj


PS once done with my project can I postit here for all to use

Hi Sir Thank you for pointing out my mistake

I formatted column F as text and from M2:u16 also as text

I attach the amended file am not sure if this is done correctly

I appreciate your time and advice and look forward to a solution if I had met all that you require.

If the contents/value in column F match es the contents/value within M2:U16, that cell must be shaded yellow.


Once all is done, it will be nice to make a list of the rows that have no shaded cells/contents or value