I have a Google Spreadsheet having possibly thousands of IP addresses extending from column A1 to column CS2990
I have a list of about 100 IP addresses
I need to color all the cells in Green which contain any IP addresses that is in the list of those 100 IP addresses.
The sheet contains IP addresses as 220.127.116.11/32 or 18.104.22.168/28 or something where number after / can change
And the list that I have contains IP addresses in the format of 22.214.171.124
So color the cells having 126.96.36.199, doesn't matter if it was 188.8.131.52/32 or 184.108.40.206/28