Is it possible to find and replace all instances of a particular text colour with an alternate colour?
The colour will only be applied to a random portion of the cell contents. Black black black RED black.
Only the red text colour should be replaced so any other colour is unchanged.
WRITER has a find & replace function that permits text format choices but that’s missing from the CALC find & replace.
Is there a possible regular expression that will achieve the objective?
Version: 220.127.116.11 (x64)
Build ID: 64390860c6cd0aca4beafafcfd84613dd9dfb63a
CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: sv-SE (en_GB); UI: en-GB