sevenfive85
New Member
- Joined
- Jul 21, 2021
- Messages
- 22
- Office Version
- 365
- Platform
- Windows
Hi all,
Can someone please help with this conditional statement? I need two things to be true for the word "Select" to appear, Cell D3 must be "Yes" and C8 must contain something. Code below is what I have but it is wrong, please help. Thank you.
If Target.Address = "$D$3" Then
If Target.Value = "Yes" And Range("C8").Value <> "" Then
Range("K8:K300").Value = "Select"
Else
Range("K8:K300").Value = ""
End If
End If
Can someone please help with this conditional statement? I need two things to be true for the word "Select" to appear, Cell D3 must be "Yes" and C8 must contain something. Code below is what I have but it is wrong, please help. Thank you.
If Target.Address = "$D$3" Then
If Target.Value = "Yes" And Range("C8").Value <> "" Then
Range("K8:K300").Value = "Select"
Else
Range("K8:K300").Value = ""
End If
End If