Aloe tips turn yellow due to cold air, most often from the window. They can also turn yellow due to pests or too little water (they are then thin and slender).