Change color based on color assigned to another doc.

[JJ_Rivera]

Hi, I have two documents with the same information, the first one already have certain cells with fonts in red color.
The second file is generated on a daily basis from SAP, I need to assign the same color on the second document to the same cells without having to go one by one to change the color.

Thank you
JJ

[daffodil11]

This would mostly likely involve the use of VBA. Since programming tends to be very specific, I'd recommend attaching examples of your work or at least create some.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[ChemistB]

If they are set up the same, can you copy>Paste Special> Format?