View Single Post
  #3   Report Post  
bj
 
Posts: n/a
Default

try a macro like

subbkck()
for r = 1 to endrow
for c = 1 to endcolumn
if workbooks("wb1").sheets("sh1").cells(r,c).formula< if
workbooks("wb2").sheets("sh1").cells(r,c).formula then
workbooks("wb1").sheets("sh1").cells(r,c).select
With Selection.Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
next c
next r
end sub

This will leave any changed cells highlighted yellow in wb1
Note if this does what you want, I would change the brute force macro to a
more formal macro with methods of having the macro select the max cells and
inputing the Workbook names. I also dim each variable and use option
explicit.
but I like brute force macros for initial set ups because it is easier to
see what they do.

"Doug Gault" wrote:

I have found many programs that will help me compare the VALUES in one
workboodk to another, but I need something that will help me compare the
underlying formulas.

We have some financially based spreadsheets that are routed through the
company for edit/review/approval and when we get them back we need to make
sure that nothing has happened to change the underlying forumlas.

I need a program/method to compare the routed spreadsheet to a "Master copy"
that will check to insure the formulas haven't changed.

Thanks