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.....