Connect
1----1
2----2
3----3
4----4
5----5
6----6
7----7
8----8
and
9----9
And use whatever colour you want.
Or do you need to do something "interesting" with the cable? Is it an RS-232 "null modem" cable you're after? Or a VGA cable? Or something else? I'm not sure what DB9's are used for any more...