After pasting only values and formats and then to mention
"to become a formula" you lost me completely. Not to mention
dates dependent on a date when there are no formulas.

<shanaron wrote...
I have excel sheet that has a vlookup formula and conditional formated
accoridning to dates.

I want to select the data and special paste only values and formats to
another worksheet and those dates to become a formula so that the
dates dependent on the date to become a X with red background and R X
with Green background and A with yellow backgound. How do I do
this.Please