Question re: Data Validations and Custom Error Messages

Hello!

I’d like to know if I can have more than one validation in a cell. I’ve created a data validation list. The options are Yes, No, Pending. If “No” is selected, I’d like for an error message to pop up. Any ideas?

Thank you!

Not using data validation, but certainly can be done with VBA.

Try inserting this code into the Worksheet module (change the variable value of targetCell to match your spreadsheet, and the error message to whatever you like):

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim targetCell As String
    
    'Change this value here to whatever is appropriate (make sure you use absolute references - "$")
    targetCell = "$A$1"
    
    If Target.Address = targetCell Then
        If Target.Value = "No" Then
            MsgBox "Enter your error message in-between these double-quote marks!"
        End If
    End If
End Sub

Hope this helps