I use this code to erase highlighted cells after a search. Is there a way to edit this that would put the original cell color back in,maybe looking at near by cell. Thanks
Sub Remove_Color()
Application.FindFormat.Interior.Color = vbYellow
Application.ReplaceFormat.Interior.ColorIndex =...