Does failing a Pass/NP course look bad?

So I somehow failed my remedial math course and ended up with a NP (No Pass) on my transcript. Is this going to look extremely bad for me when I apply as a transfer student to a University? My goal is to shoot for a pretty prestigious school, so I know trying to get accepted with anything less than a 4.0 will be difficult. Failing this course didn’t effect my GPA, but I’m worried that having a NP on my transcript will still hurt my chances anyway.