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