VBA .Interior.Color.Red then enter text...

[Pinaceous]

Good Day All,

If I'm working with cell E11:E180 where its interior color turns red through CF.

Now, how do I provide through VBA where if this cell's interior color turns red that the text appears "RED"?



As in:

Please let me know as soon as you can thank you!

R/
pinaceous

 

[Pinaceous]

Yes, you will have to ditch the CF. VBA might be something like

If Range("E11")="" And Range("F11")<>"" Then
    With Range("E11")
        .Interior.Color = vbRed
        .Value = "RED"
    End With
End If

Copy that Micron! And thanks for the code!