How can I easily change all the red font words that are spread through my doc to have them being all blue?

I have a document with half of the words in Font black and half in red. The red words are here and there and everywhere and mixed with the black font words. I tried using the find and replace feature but was unsuccessful. Does anyone know an easy way to change all the red font to a different color font without clicking on each word separately?

To avoid similar issues to come: Use named cell styles and conditional formatting where appropriate.

@Lupp’s comment is for Calc.

Hmm. Sorry!

Find and Replace works, but you have to have the right color specced.

Select a red word or character, right-click and select “Character…”.
The Font Effects tab will be preloaded with the present color.
Now do a Find using Other Options / Format button to spec that font.
Click in the Replace field and use the Format button again to spec the desired color.
Test once to see if it works, then click Replace All