Conditional formating with Message Box

[Gregm66]

Hi All,

I have set conditional formatting to cells on my worksheet that detect if the same value appears.
IE: If cell B6 value is "V10" and cell B14 value is "V10" then cell B14 color changes and text turns bold.

Formatting rule = "Format only cells that contain" - This is in cell B14
Cell B23 would be ( Cell Value. equal to. =($B$6:$B$14)
and so on down column B

what i am wanting to do is show a message box if the Value of cell B14 is the same as the cell value in B6.
this will continue down the Cells for that column if duplicate values are found.

Preferably done using VBA

I hope that my question is easy to understand.

Thanks in advance for any help.

 

[Gregm66]

[h=2]Conditional formatting with Message Box[/h]This question has been solved please see below for my solution.

Private Sub Worksheet_Change(ByVal Target As Range)
    
    If Range("B14").Value = Range("B6").Value Then
        MsgBox "Please Check Vehicle Allocation, Duplicate Allocation Detected"
    End If

End Sub