Hi,

I am trying to create an add-in that will identify cells with formulae that have a different formula €˜structure to those cells around it (i.e. The 4 adjacent cells surrounding this cell- I wont have any cells in the first row or column to worry about). As most formulae in a list are either copied down or copied across (or both), I am aiming to identifying the cells with €˜fudged/manually edited formulae.

For example, say that all cells within a range A1:E10 except B3 contains a SUM function (say range A1 has €œ=SUM(F1:H1)€� and then copied across and down), whereas cell B3 might have been manually changed to €œ=B2€�.

Is it possible to identify B3 as a fudged cell using VBA (after which Ill set its font colour to red)?

The approach that Ive thought of is, for each cell in Specialcells(xlCellTypeFormulas), compare it with the 4 cells to the left and right and top and bottom of it, and make its font red if it has a different formula structure to, say, more than 2 of these cells (to allow for there being 2 fudged cells in proximity).

I am using Excel 2000.

Thankyou so much for your help in advance!

SuperJas.