Conditional format in macro, does not fully work

Hello, I'm new at this forum and in need of help.

I'm trying to compare one range of cells (RANGE 1) with another range of cells (RANGE 2), using conditional format I would like to highlight the cells with the same value in RANGE 1 and RANGE 2.

So I select RANGE 1 --> Conditional format -->"Formula is" and fill in: "=or(value(A1)=value(RANGE 2))". With A1 being a cell of RANGE 1, give it a color format and apply.

The cells in RANGE 1 that have the same value in RANGE 2 are now highlighted. So far so good.

But if I do the exact same thing while recording a macro, and I start the macro, only A1 is highlighted and the other cells that should als be highlighted are not. They are only highlighted after I open the conditional format in each individual cell and just pressing ok.

You can see it in the excel file I'm attaching.

Thanks

Thanks for the reply, I forgot to say that I kinda suck at VB.

So when pasting your code in VB editor, this line

Please Login or Register  to view this content.

gets highlighted in yellow.

It works now, the problem was the comma separator, apparantly in europe we work with ; as a separator.
Thanks a lot. I'll have another go at it after lunch break.