RGB color codes?

[regwitt]

I am trying to embed an IF statement within another IF statement with a condition that would change the color of the cell. I'm aware of macros and really don't think it should be that complicated.



=IF("",RGB(255,0,0),"") WHY NOT!!!!

Is this possible? If so please help.

Thanks in advance.....

[excelledsoftware]

So are you looking to do this in VBA? if so you need to put some more code in so that your program know what objects to look at. Start with this

If Range("A1").Interior.ColorIndex = 4 Then
  If Range("A1").value <> "" Then
    msgbox "This cell equals nothing and is green."
  End If
End If

[CoolBlue]

I can't tell much from your question but if you want to change the colour of a cell using a formula then conditional formatting is what you need.