VB Code to highlight the cell

Perhaps

Option Explicit

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim LR  As Long
   If ((Target.Column < 2) And (Target.Column > 4)) Then Exit Sub
   LR = Cells(Rows.Count, 2).End(3).Row
   If ((Target.Row < 2) And (Target.Row > LR)) Then Exit Sub
   Target.Interior.Color = 49407
End Sub

A remake
It works for all sheets then it can be done a selection
in module ThisWorbook

Option Explicit
Private Sub Workbook_Open()
    Application.OnKey "~", "ColorCell"
End Sub

in a module put

Option Explicit

Sub ColorCell()
Dim LR  As Long
   If ((ActiveCell.Column < 2) Or (ActiveCell.Column > 4)) Then Exit Sub
   LR = Cells(Rows.Count, 2).End(3).Row
   If ((ActiveCell.Row < 2) Or (ActiveCell.Row > LR)) Then Exit Sub
   ActiveCell.Interior.Color = 49407
End Sub

Works for me. However, you should note that a) it affects all workbooks and b) the key is not cleared on exit.

Ideally, the Onkey code should be initiated and cleared on worksheet activate and deactivate respectively.

After checking again the file it works ....
To go forward and to care about TMS' comments here a remake.

in ThisWorkbook

Option Explicit
Private Sub Workbook_Open()
    Application.OnKey "~", "ColorCell"
    FileName = ActiveWorkbook.Name
End Sub

in a module put

Option Explicit
Public FileName  As String
Sub ColorCell()
   If (Intersect(ActiveCell, Range("B2:D14")) Is Nothing) Then Exit Sub
   If (ActiveSheet.Name <> "Data") Then Exit Sub
   If (ActiveWorkbook.Name <> FileName) Then Exit Sub
   ActiveCell.Interior.Color = 49407
End Sub

I think you also need this:

Option Explicit
Private Sub Workbook_Close()
    Application.OnKey "~"
    FileName = ActiveWorkbook.Name
End Sub

That would be a Worksheet Change event handler. You specifically said, highlight the cell when you press Enter. A WSCeh would be a whole lot easier.

Is next code gives what you need ...?

Private Sub Worksheet_Change(ByVal Target As Range)
   If (Intersect(Target, Range("B2:D14")) Is Nothing) Then Exit Sub
   Target.Interior.Color = 49407
End Sub

You're welcome. Thanks for the rep.


If you'd said this

Is there a way that it can only highlight if any changes to the cell is made. (post #9)

in post #1 and/or post #3, you'd have got the WSCeh from me way back. Credit to PCI for his solution ... I wouldn't have thought of that, and I'm not really keen on using OnKey.

Good news
Enjoy Excel