Format painter help!!!

[iowitz]

What is the fastest way to format painter from one workbook to another?

I need to format painter "workbook 1" cells, A-BJ to "workbook 2" cells A-BJ.
I need to do this for over 500 workbooks.
Is there a special formula I can use or macro to format these fast?

 

[shyy]

turn on the macro recorder, instead of using the format painter, recreate all the steps (if not too much formatting) and run the macro on another workbook.

 

[iowitz]

Can you explain how to do that please, record macro ect

 

[shyy]

Highline Excel Class 52: Recorded Macro Basics - YouTube