Replace Conditional Formatting with Direct Cell Formatting
Hi All
I have a spreadsheet with a stack formatting some of which is direct e.g. various borders but a lot of which is conditional using vlookups involving named ranges in a separate sheet
Ultimately I want to lift a completely standalone copy of the sheet so that all the values are static and all the formatting is direct cell formatting so there's no reliance on any other data source
Making the values static is easy (Paste special > values) but I not been able to find a way to convert conditional formatting to direct cell formatting
I've done some research and found a downloadable set of add-on tools that includes a conditional convert feature but that same set of tools also includes features that I know are built into Calc e.g. converting character cases which makes me think the conditional convert tool is using an existing built in feature but is making it easier to access in some way
Before I go digging into the conditional convert tool to work out how it works can anyone tell me if I'm missing something and that there is already a convert feature built in but I'm just not seeing it
tia
Version: 26.2.4.2 (X86_64)
Build ID: 620(Build:2)
CPU threads: 32; OS: Linux 6.17; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-US
Ubuntu package version: 4:26.2.4.2-0ubuntu0.24.04.1~lo1
Calc: threaded