Thanks, no. It's boring and tedious and lots of manual work. As I do it, I'm learning the workbook, using little macros here and there to help me out.

Actually... I could use a macro that finds in original.xls, which is open, all cell formats that have decimal and comma formats, and also percent formats, and copy the format over to its corresponding cell in annetemplate4.xls, which is exactly the same, but has two sheets added. What a pain! I have this code, but it must not have worked right:

[vba]Sub CopyFormats()
'Copy all formats from one workbook to another
'Requires sheets to be indentical in each workbook
Dim wbOriginal As Workbook
Dim wbTarget As Workbook
Dim ws As Worksheet
Dim cl As Range
Dim testrange As Range
'Set workbook names here
Set wbOriginal = Workbooks("original.xls")
Set wbTarget = Workbooks("annetemplate4.xls")
'Turn off screen updates for speed
Application.ScreenUpdating = False
'Loop through each sheet copying formulas to target workbook
For Each ws In wbOriginal.Worksheets
Application.StatusBar = "Processing worksheet: " & ws.Name
For Each cl In ws.UsedRange
If cl.FormatConditions.Count > 0 Then
Debug.Print ws.Name & "!" & cl.Address
cl.Copy
wbTarget.Worksheets(ws.Name).Range(cl.Address).PasteSpecial Paste:=xlFormats
End If
Next cl
Next ws
'Resume screen updates and clear statusbar
With Application
.ScreenUpdating = False
.StatusBar = False
End With
End Sub
[/vba]