cell colors in Excel 2013

Copper Contributor

is there a good way to get cell colors from an existing document into a an excel 2013 spreadsheet? I have multiple spreadsheets I've been using for years with colored cells. I was just switched to excel 2013. when I copy the filled cells from the old doc, they paste into the new doc a completely different color! yes, I can manually go in and enter the number values to match what's in the old doc. That is not efficient and a terrible waste of the work day. is there another work around?

 

additionally, the fill colors in some spreadsheets no longer match the master spreadsheet. every time this comes up, i must check the full contents of the two cells to verify they are the same. this has a large impact on productivity. am i the only one having this kind of issue?

0 Replies