find rows with a unique asset ID

Hi,

Need help in finding rows with a certain asset id's and shortlist or highlight them

for example:

there are three asset ID's in a column

1. P111
2. P241
3. P120

then there is a range with several rows

1 2 P178 692 2 Pit Replace Lids 100 Fourth Avenue 3
2 1 P10252 39 4 Pit 5 Pit Asbestos Upgrade 110 Fifth Avenue 4
3 2 P10252 39 4 Pit 5 Pit Asbestos Upgrade 110 Fifth Avenue 4
4 2 P111 210 NEW 5 Pit Plastic NEW 145A First Avenue 2
5 1 P268 39 B Pit 5 Pit Asbestos Upgrade 110 Fifth Avenue 4
6 2 P268 39 B Pit 5 Pit Asbestos Upgrade 110 Fifth Avenue 4
7 2 P10203 40 5 Pit Locate/ Expose 114 Fifth Avenue 4
8 2 P48 26 3 Pit 5 Pit Asbestos upgrade 89 First Avenue DFN
9 2 P128 184 C Pit 5 Pit TBC Upgrade 137 First Avenue 2
10 2 185-PIT-001 185 NEW 5 Pit Plastic NEW 139 First Avenue 2
11 2 P112 210 B Pit 6 Pit Asbestos Upgrade 147 First Avenue 2
12 2 001-PIT-212 212 6 Pit Asbestos New 155 First Avenue 2

now want a function to look up for the rows and possibly highlight with yellow color those rows only

Attached the excel sheet for your reference, the asset ids i am looking for are in column C, and the range is E to P

You guys help is much appreciated



regards,

Hi Dibbins,

As you can see I have manually highlighted asset ID P111 when it appears in the row 5 column G

same way want to highlight all the entries of column C