Here’s how to reproduce it. In a cell, type “the quick brown fox”. Then format the word “brown” with some color. Then type ctrl+h to bring up Find & Replace, enter “the” in the “Search for” window, enter “a” in the “Replace with” window, click Find, then click Replace. The text is replaced successfully, but the color has disappeared.
