On Sep 23, 1:41 pm, "David McRitchie"
wrote:
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- Hide quoted text -

- Show quoted text -

I am pulling data with the v lookup function in a workbook which also
condtional formats. Using that data I would like to make e.g. any
date less than 01/09/2007 become R with red background and anything
greater than 02/09/2007 become R X with green background. Can this
be done. Currently trying to hand over the data.