Run formulas with macro but compare values in cell

Hi I have below code which pin out numbers from IBAN in Column P. Its formulas run by macro. It works fine.
But what i really need is that instead of putting the formula in the cell, is that it compare the value from the formula, with the excisting value , in each cell . And it mark the cells where there are a difference with yellow colour
I have been thinking how to do this but cant really work it out.
If some have a better solution its ok but i need a macro for it.

Please have a look at below code, which change the cell and correct the error, but which i want just to compare the values.

I have attached a sheet to test with.

Thanks

Sincerely
Abjac

The code.

Please Login or Register  to view this content.

Hi jessebranum. Yes this is exactly what i need, its a great code. Only thing is that it replace the value in the cells, which are not colored,with the formula. I would prefer the value. Done know if that can be done. But your code do it i think. Please have a look at the value, if is possible to keep it in the other cells.

Thanks in advance

Sincerely

Abjac

No not really. I would like to not have the formulas, but the value also in the cells, where it don't find any difference.
As it is now it change the value in these cells to the formula., when I enter the cells.

But I discovered another more big problem for me. I suddenly was using it with IBAN which have letters in the account number. And here the code stop working.
I have uploaded a new sheet to look at with other IBANs where in some, there is letters in the account number,

If you can solve this its more important really.

Please have a look at the new test sheet below

Thanks

Sincerely
Abjac

Hi Jessebranum777. Its nearly there. But please try run the new code in below sheet. It make an weird error in H14 and also it select H15 even if it should select A1. Please try run the code in the sheet I upload. But I think its close to work there. So have a look and try in the sheet. Inputformula14 is your new code to run

Thanks in advance

Sincerely

Abjac

Even better here. Try this sheet much more to validate. When there is no IBAN in column P it should give a yellow. But it stop run in column H..
Please also try this new sheet with more items.

Thanks in advance

Sincerely
Abjac

Hi Jessebranum. I think i put both macro in d last testsheet here. I am on d way home. But will have a look when home. Thanks Abjace

Hi Jessenranum. I tested the code in a big sheet the last code and it works brilliant for sure. Thanks allot for all your effort. Its a big help for me, so thanks allot.

Have a nice day

Sincerely
Abjac