excel compare two columns and highlight missing

excel compare two columns and highlight missing

Hi.

I wanted a Excel expert, who can create a script in excel for compare two columns and highlight a missing data. The Column1 will have a full list of IP´s and Column2 will have a exported running servers IP´s with missing (dropped) IP´s.

For example:

LIST1: (all IP´s)
36.125.2.1
98.102.1.3
74.54.3.11
.. more that 500 rows..

LIST2:
74.54.3.11
.. more than 500 rows

Script will highlight a missing IP´s, or show a dropped IP´s in the another column

Missing IP´s:
36.125.2.1
98.102.1.3
43.44.122.3
etc...

Thanks for you bids

---

Requirements

Excel experts
Must be capable with Excel 2010+

---

Skills Required

Excel