Take a look at Format / Style

Sub sheetformat()
Dim ws As Worksheet
For Each ws In Worksheets
With ws.Cells
.Font.Size = 8
.Interior.ColorIndex = 24
' etc etc
End With
Next
End Sub


"dadospartacus" wrote:

Anybody know how to write a vbscript that can copy font setting like size or
color from sheet1 to another sheet. Both sheets have the same information
on it so that if you change the font size on cell B2 on sheet1 the
corresponding cell on sheet2 would be the same. Hope this make sense and
somebody knows how to do this. Thanks for all your help.