My OpenOffice Calc is actually the LibreOffice Calc that comes with Trisquel
(flidas). The link that I'm attempting to follow is here:
https://stackoverflow.com/questions/35822359/highlight-duplicate-value-in-openoffice-calc
At the bottom of that page is the suggested solution:
"If you want to format any value in a cell that is a duplicate of the one
immediately above it, select the entire column and use the following formula
in Conditional Formatting:
"(INDIRECT(CELL("address"))=OFFSET(INDIRECT(CELL("address"));-1;0))"
But when I select Conditional Formatting, the drop-down menu is
uncooperative, and I've no idea how to proceed ... anything I do just freezes
the program.
I'm presuming that after I've color-coded the duplicates, that I can
thereafter separate the color-coded ones from the rest.
