Excel 2016/365 has no problem using another sheet in conditional formatting. The formula might be along the lines of =ISNUMBER(MATCH(E5,Sheet2!$A$1:$A$24,0)) but if you could supply a file with sample data we could give a more definitive answer.