Google docs search

gdox.js

var statusColumnOffset = 0;
var range = SpreadsheetApp.getActiveSheet().getDataRange();

function setRowColors() {
  for (var i = 0; i < range.getLastRow(); i++) {
    findFrodOfIP(i);    
  }
}

function findFrodOfIP(ipIndex) {
  var ipRowRange = range.offset(ipIndex, statusColumnOffset, 1);
  var ip = ipRowRange.offset(statusColumnOffset, statusColumnOffset).getValue();
  
  if (ip && ipRowRange.getBackgroundColor()) {
    frodPartOfIP = ip.substr(0,11);
    for (var i = 0; i < range.getLastRow(); i++) {
      var rowRange = range.offset(i, statusColumnOffset, 1);
      var ipCandidate = rowRange.offset(statusColumnOffset, statusColumnOffset).getValue(); 
      if((ipIndex !== i) && ipCandidate && (ipCandidate.toString().match(frodPartOfIP)==frodPartOfIP)) {
        rowRange.setBackgroundColor("red");  
      };     
    }
  }
  
}