You didn't specify your brand and model, but often a red or orange or blue light is merely to signify that the new video graphics card is on and working properly. If everything seems to be working normally, it probably is.
You would have to look up your system on the manufactures website, or the motherboard makers website to see for certain what the purpose the light holds