rpmfind.net is your friend; you can type in most dependencies there and
find a package that provides them. Don't start installing packages from a
whole range of vendors however; in general, stick to redhat packages, as a
second choice freshrpms, and as third choices PLD and sourceforge stuff.
You probably need to make it provide other stuff, like webserver, as well,
under Red Hat.
This way you as the user tell the rpm database that apache exists on your
system. As an administrator you will have to remember that this is a
DUMMY package and doesn't actually contain anything, but is just there to
satisfy the dependencies.
The BEST way to fix this is to just get a REAL Red Hat package of apache
2, and I'm sure someone out there will at least have made some.