E46M3s Hello. I do no know the solution to either of your problems, therefore I'm only guessing. Seems like you have two abnormalities:
Which Dell Optiplex 790 case form factor do you have btw?
BIOS error lights: Replace the CMOS battery, since your system is eight plus years old. I suspect that the error lights are a false positive, related to your CMOS battery most likely being dead.
RX 580 preventing system from booting: The fact that it artifacted on your buddy's build, isn't a good sign, but clearly it booted in his system. You'll need to provide the following information:
Full system specs, including the manufacturer and model of your power supply.
The full model name of your GTX 950
The full model name of your RX 580; are both PCIe power connectors plugged into your power supply? Are you resorting to an adapter to do so?
Please take two photos: (1) The full inside of your build; I specifically looking for the power connectors on your motherboard. (2) The label on the side of your power supply. Then upload both photos to imgur and share the link here.
Addendum: Before you do anything (above), I recommend that you update the BIOS to the latest version using support.dell.com. Then go into the BIOS and make sure that "secured" mode is disabled.