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