How long from the point of tingling, will a cold sore appear on your lip?

Next day. Within my experience, people complain about tingling (on a lip or elsewhere; wherever they happen to get their sores) or itching, or pain, about one day before the sore appears.
Usually a day. Classic "prodrome", tenderness, tingling, itching within about 18-24 hours before outbreak.