Hi
I would like to automatically Find and Replace specific font color(s) in a specified range (on one page/sheet) of a spreadsheet.
In the example attached (Example colorchange.ods) [can’t attach, see image],
https://freeimage.host/i/dEPuwhu
the requirement is:
In the range: startpoint.h3:i14
anything in any form of green (light green 1, light green 2, etc) should be changed to Dark Green 2
Anything in any shade of “orange” (Light Brick 2, Light Orange 3) should be changed to Orange.
No other font colors should be changed. Reds and greys should not be changed.
Nothing outside of the range h3:i14 should be changed.
No ‘styles’ have been used, all colors have been added manually using Libreoffice’s standard palette (no custom colors).
Each cell is colored as a complete cell (i.e. there are no instances where different words inside a cell were colored differently from each other).
I am happy to run each change of color-pairs separately (e.g. first do “light green 1 to Dark Green 2” ; then “light green 2 to Dark Green 2”, etc.)
Version: 24.2.5.2 (X86_64) / LibreOffice Community
Build ID: bffef4ea93e59bebbeaf7f431bb02b1a39ee8a59
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: threaded
p.s. I found a similar question from 2017 that dealt with the background colors of cells (I am not interested in that)
https://ask.libreoffice.org/t/calc-find-replace-background-color-in-cell-range/29189
I thought that I might be able to adapt that to my needs (but I couldn’t even get it to work for its intended application! - I might need some hand-holding if I will need a macro/VBA)
thanks a lot 