Calc find & replace (word color)

in Calc find & replace I want to find a word then replace it with the same word but in a different colour, and font if possible.

How do I do that

You might find the answer at How can I easily change all the red font words that are spread through my doc to have them being all blue? useful.

I haven’t tried it in Calc but I don’t see why that should differ from Writer.