Which type of bone marrow is able to convert into the other, and under what circumstances?

Describe the functional differences between red and yellow bone marrow, and where they are generally located.