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 126.96.36.199/32 or 188.8.131.52/28 or something where number after / can change
And the list that I have contains IP addresses in the format of 184.108.40.206
So color the cells having 220.127.116.11, doesn't matter if it was 18.104.22.168/32 or 22.214.171.124/28