Validating cells based on content and background color

Hi GeneralDisarray,

Listed below is some code that changes the interior.colorindex to yellow based on a couple of conditions:

If Target.Column = 95 Then
    
    If Target.Text = "Yes" And Target.Offset(, -1).Text = "Yes" Then 
      Application.EnableEvents = False
      range("CR" & ActiveCell.Row & ":CV" & ActiveCell.Row).Interior.ColorIndex = 6 'change background color to yellow
    Else
    End If
End If

Depending on the value of column 94 and 95, the interior.colorindex could be black, yellow or xlNone. If it's black or xlNone, entry shouldn't be required. Only if there is a yellow background.

In your first suggestion, what would the named formula look like?

Thanks, so much, for your help!