It loses the conditional formatting when a new set of data is pasted in...or I broke the formula when I changed the range. Where's the highlight function stored? In the formula or the cells, so if I paste overtop, am I clearing that Cond. Formatting?