Spreadsheet Review Macro

[Nick Ward]

Dear All

I am after a macro that anyone may have devised which
looks line by line and judges whether the row has a unique
formula at the begining which is the same all the way
across, then skips down to the next row and colour codes
if it finds any unique formulas, then will skip sheets and
go to the next sheet and repeat until the end.

If anyone can help out it would be greatly appreciated.

Cheers
Nick

 

[Frank Kabel]

Hi
what do you mean with 'unique formula'. Could you give an
example?

 

[Nick Ward]

Hi Frank

In a financial model I want to ensure that the formula in
the first cell is copied across properly and is not hard
coded or that the formula changes progressively through
the row. For consistency and transparency the formulas
should all be the same

 

[Frank Kabel]

Hi
you may post your current formula. But from your
description it sounds like you need absolute references.

but as said: post your desired formula