Good afternoon, all. Thanks for taking the time to review my question.

I've been given two worksheets with identical structure and have been asked to copy the cell format (color) of the dollar amounts in column J on worksheet "201503 - Summary" to the dollar amounts in column J on worksheet "201504 - Summary" when the account numbers in column A of worksheet "201504 - Summary" match the account numbers in column A of worksheet "201503 - Summary". There are two different cell colors used rather than just one.

I don't believe that this can be resolved with a formula and so am posting it here in the Programming/VBA/Macros forum.

I hope I've explained my predicament sufficiently and appreciate any assistance you can provide.

Make it a great day!