Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
up vote 0 down vote favorite

I have an Excel workbook with too many columns and rows and I get its update every week.

I classified the workbook myself by different filling color in rows, when I get the update version ( it is not classified and has no filling color).

I want to copy the format (filling color) of previous workbook for those cells which have the same content, for this it takes too long to look up a value and then copy the color from previous workbook.

Can someone help me?

In vlookup formula it just copies the value but I want to copy color and format cell.

share|improve this question
why don't you update your formatted file instead?! it's easier to merge data instead of merging formats. For the latter you will need VBA, because there are is no way to use formulas to change the format of a cell (like the backgroundcolor). – Jook Nov 19 '12 at 8:35

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.