I have a Google Spreadsheet having possibly thousands of IP addresses extending from column A1 to column CS2990
And
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 1.2.3.4/32 or 7.8.9.10/28 or something where number after / can change
And the list that I have contains IP addresses in the format of 1.2.3.4
So color the cells having 1.2.3.4, doesn't matter if it was 1.2.3.4/32 or 1.2.3.4/28