My PC doesn't go past the motherboard manufacturer logo. I tried to reset the BIOS. I have two RAM slots and 1GB RAM. I tried reinserting the RAM in other slots.
I think the red light shows that the hard drive is working fine.
Try cleaning up the insides of the CPU (specifically the RAM, processor etc) with a vacuum cleaner. This worked for a friend of mine who had the same problem.