I've gotten the LED to be Red, Green, and Blue. Need to try yellow and see if that works. Some Apps have even better customization for notifications than the stock system.
I use SMS Popup, which puts an incoming text message over the lock screen and allows custom colors and tones for individual contacts. Works well for me, but I don't have a lot of text contacts.