Hmm, all the refined palm oil I've gotten was just white - well slightly off-white really but not any shade of green.
The red stuff is unrefined and will indeed color your soap. Depending on how much you use your soap may end up anwhere from pale yellow to seriously orange.
You say you ordered it? (the green stuff). do you mind saying from where?