display message when values in 2 cells don't match.

Hi
Can someone give me an idea of how can I display some sort of warning/message when values in 2 cells don't match?
Please see the sample book there are 2 rows which have a New Version and current version when new version of the document is creadted all cells in this column will go red but I would like to have some sort of message if possible.
Appreciate your help.
Thank you
Dan

Originally Posted by HaHoBe

Hi, ciapul12,

maybe save the workbook as macro-enabled and add two procdures.

ThisWorkbook:

Please Login or Register  to view this content.

Behind Sheet1:

Please Login or Register  to view this content.

Ciao,
Holger

Hi
Thanks so much for your help I really like the idea of having macro doing it for me, however it seems there's a mistake in a code as it says "No match in version in D2" it should say B2 instead as this is where the change was made. in addition to this would it be possible to have a name of document in this message so for example if I change version No in document named "Procedure1" in the message it would say for example : "Procedure1 has been amended, new version is v4"

Thank you
Dan

Originally Posted by HaHoBe

Hi, ciapul12,

ther愀 a general problem as the message box would be two columns off of the cell which really shows the mismatch (seems I don愒 know the Offset properly this Sunday) . Please replace the codelines

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

which will take the name of the procedure from Row 1 and the new Version from Row 2.

Ciao,
Holger

Hi Ciao
This is exacly what I was after.
Thaaaaannnnkkk youuuuuuu.7
You're awesome!!
Dan