VBA - two target cells, two IF conditions to Call a Macro

[kevinruairi]

Good afternoon (or other time of the day, depending on where you are)

I have a spreadsheet with a macro in it that gets called with the following condition

Set target = Range("E2")
If target.Value = "TRUE"
 Call SubmitRequest02
End If

So what I want to do is Call SubmitRequest02 only with the following conditions:

E2 contains the Value "TRUE"
And
D2 cell colour is NOT RGB(255, 0, 0) - which I think is the same as vbRed

It seems fairly simple but I'm having difficulty with the multiple conditions.

Apologies to say my VBA is rusty would be an understatement.

Thanks for any help you can give.

 

[Fluff]

Try

If LCase(Range("E2").Value) = "true" And Range("D2").Interior.Color <> vbRed Then
   Call SubmitRequest02
End If

 

[kevinruairi]

Try

If LCase(Range("E2").Value) = "true" And Range("D2").Interior.Color <> vbRed Then
   Call SubmitRequest02
End If

Works perfect. Thank you so much.

 

[Fluff]

You're welcome