thanks very much Richard Buttery.

if the cell already have the date and conditional format have not put in yet, can i paste the conditional format into the cell only without change the date ?