Hello,

This does not work when the columns and rows are different.
Any idea on how to do this with them being different?

Thank You
Kent

"CLR" wrote:

Hold down Ctrl and Shift and highlight both sheet tabs........then do the
formatting.....it will take on both sheets


Vaya con Dios,
Chuck, CABGx3


"Kent" wrote in message
...
Hi,

I have an excel file that has two worksheets in it. On Sheet1 when I put
data
in it and change the font/color/bold is it possible to carry that over to
Sheet2
automactically?

Please let me know

Thank You

Kent