I have several "data" spreadsheets that I copy into a "master" sheet ... do a couple of VLOOKUP's and then conditional format rows that meet my searches.

THEN: I need to copy & paste the "data" sheets back, but want the cellls to keep the conditional format. The problem is the columns that I copy back do not have the VLOOKUP data in it, so the format drops.

Is there any way to copy is back & keep my formats ???

Thanks !!!