D
Dave
I think I understand what you are asking...
I'd just do something like:
If Range("A1").Value > 500 Then
x = "red"
ElseIf Range("A1").Value < 200 Then
d = "green"
Else d = "yellow"
End If
I'm certainly no expert, but I'm pretty sure that would
work. Hopefully it helps, people here have been really
helpful when I have problems, so I thought I'd give a
little something "back" to the community.
Dave
I'd just do something like:
If Range("A1").Value > 500 Then
x = "red"
ElseIf Range("A1").Value < 200 Then
d = "green"
Else d = "yellow"
End If
I'm certainly no expert, but I'm pretty sure that would
work. Hopefully it helps, people here have been really
helpful when I have problems, so I thought I'd give a
little something "back" to the community.
Dave