[Solved] Find Cells Which Have Been Conditionally Formatted
[Solved] Find Cells Which Have Been Conditionally Formatted
As may be inferred from the Subject, is it possible in OpenOffice to locate within a spreadsheet all those cells in which there has been conditional formatting?
Last edited by Hagar Delest on Tue May 18, 2021 7:55 pm, edited 1 time in total.
Reason: tagged solved.
Reason: tagged solved.
Re: Find Cells Which Have Been Conditionally Formatted
Install this extension: https://extensions.libreoffice.org/en/e ... /show/1983
After restarting the office suite, you should find menu:Tools>AddOns>SpecialCells>Formatting ...
A dialog pops up showing the collection of equally formatted cell ranges.
Check the "Group" option and walk through the yellow list. When you hit a collection of ranges having some conditional formatting, you will notice the entry <Conditional> in the attribute list.
Alternatively, you may simply replace OpenOffice with LibreOffice. LO Calc has a modernized management of conditional formattings, allowing more than 3 conditional formats and finding all conditional format ranges on the active sheet.
https://www.libreoffice.org/discover/li ... penoffice/
After restarting the office suite, you should find menu:Tools>AddOns>SpecialCells>Formatting ...
A dialog pops up showing the collection of equally formatted cell ranges.
Check the "Group" option and walk through the yellow list. When you hit a collection of ranges having some conditional formatting, you will notice the entry <Conditional> in the attribute list.
Alternatively, you may simply replace OpenOffice with LibreOffice. LO Calc has a modernized management of conditional formattings, allowing more than 3 conditional formats and finding all conditional format ranges on the active sheet.
https://www.libreoffice.org/discover/li ... penoffice/
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice