Hi!

I need help writing some VBA code that can help me make sure that the reference in one cell points to the correct corresponding cell.

The background:
I have one one year end report in columns A-J and in columns M-V I have an exact copy, only that the right one is translated into an other currency. Each cell in the right one refers to the corresponding cell 12 columns to the left, multiplied with one of four cells depending on which exchange rate that should be used. I use the goto menu to colour the cells, in the right one, that corresponds to the four different exchange rates, and I am happy with that validation. But to the problem..

Problem:
I want to make sure that each cell in the right one, that have a formula, looks 12 columns to the left for the first part of the formula. The code should be looped until all formulas are checked, and if the cell reference isn't 12 columns to the left, the cell not meeting the criteria should be coloured. This code must not look in cells M118-M121 (where the exchange rates are) and any reference to these cells must be overlooked.

Does anyone have a solution? It would be deeply appriciated!

Thanks,
Mathias