Thanks for the useful info here.... I have a light arriving tomorrow and I am going to have a go at it over the weekend.... I have a switch that controls an outlet. I want that switch to control the new light I install. I think i can get a rough idea of what to do from other threads here. no doubt I will run into little issues as I am doing this in my family room (no attic access) Any tricks of the trade for getting the wires where I need them without making 'much' mess of the wall and ceiling?[I do have a basement with full access is this helps (crossing my fingers for a magic way of doing it)

I would like to replace an existing ceiling fan. This old fan (with light fixture) could only be controlled through its remote control. I believe a switch was wired to control this fan. The switch (fourth in the gang box) operates nothing. 14-3 with ground ran to the ceiling. Neutral from this circuit connected to white on fan/light. Black AND red from circuit were connected to black on fan/light. Once again, switch controlled nothing... that i am aware of. One way switch with black and red wired to terminals. Help please!