VBA If statement

[Pinaceous]

Hi All,

If I have a cell that has both an interior yellow color with the text "TEST" as can be seen in the picture below:

How would do I create a vba if statement to say if both E has an interior color yellow and has the text "TEST" and the user wants to override/enter in a new value; it will return that new value and the interior color then goes away?

For example, If the user wants to override/enter in the value "Start" as seen in the picture the vba code will remove the interior color condition and text and provide whatever the user now entered.

Please let me know.

Thank you!
pinaceous

PS. I'm interested in vba format in lieu of conditional formatting.

 

[igold]

Try this in the corresponding Worksheet Module. Please note that changing the text back to "TEST" will not change the interior color back to yellow.

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("E:E")) Is Nothing Then
        If Target <> "TEST" And Target.Interior.Color = RGB(255, 255, 0) Then
            Target.Interior.Color = xlNone
        End If
    End If
End Sub