link cell formats

I know that I've been able to do this before, but can't seem to figure it out now. I want to paste a link and maintain formatting that varies within the cell contents. See below. origin cell has, in this case, one word that is colored, bold, and italic that I want repeated in linked cell: ( I...

Hi, I am trying to create a work book containing names of people with the color coded dates if that certain item is near expiry or is already expired. I have done that conditional formatting, however the data is too many for me to narrow down as to what has expired. Question: I created a new...

Hi there, i am still quite new with excel. I have excel 2010. I know how to link columns between worksheets but what i want to do is link a column of contents from one worksheet (e.g. WS1) to a column in another worksheet (e.g. WS2). But also i want to link a column of varying background...

Hi there!! I am using a vlookup formula to pull data from one worksheet into another. The data in the source worksheet is also formatted (NOT conditional formatting). How can I pull not only the data, but also the *cell formatting* from the source worksheet into the destination worksheet?? I...