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.