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