Is it possible to automatically change a users input in a cell if it doesn't meet certain criteria?

[Recompense]

I'm trying to set up a cell where a user can enter a dollar amount and have excel check if that amount meets the minimum threshold I've set, AND if it does not, automatically update their input to the minimum amount.
eg. cell A1 is blank and awaiting users input, I've specified it needs to be >= to 10% of 500 but the user enters 25 into cell A1, I want the program to change their answer within cell A1 to 50. Is this possible with excel?

 

[rpaulson]

Try Data Validation

or via code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
       If Target.Value < 50 Then Target.Value = 50
End If
End Sub

 

[Logit]

Another method :

Option Explicit

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Range("A1").Value = "" Then
        Range("A1").Value = ""
    ElseIf Range("A1").Value < 50 Then
        Range("A1").Value = 50
    End If
End Sub

 

[Recompense]

That's great thank you both

 

[Logit]

You are welcome.