Covington, Astrophotography for the Amateur, 2nd ed., recommends 200-400 ISO color film, slide or negative, with exposures varying from 2 to 60 seconds with the lens wide open, but no wider than f:1.7.
Some auroral displays change and "move" relatively quickly, so if you want to see more structure in the rays and curtains when that's happening, stay with the shorter end of the exposure range.
Shoot a lot. Bracket with time a lot. Have a second body to reload while shooting with another if you can. Take plenty of film. You don't want to be reloading in the dark during the minute or two of the best display, or run out of film when it's just getting really good.
Don't expect to get on film exactly the colors that you recall seeing. The dimness of the display and the match up between the limited spectral lines emitted by the atmospheric gases and your film's spectral response may yield some surprises.
Lee
P.S. Was reading and typing while bobwysiwyg was posting... nice reference page.