LO 24.8.3.2
macOS 12.7.6
In a sheet with 50 rows and columns A to F, I need Calc to highlight (= apply a cell style to) any four horizontally adjacent cells in columns A to D that are duplicates. So in test-duplicates.ods (20.1 KB), cells A2:D2 and A29:D29 should be highlighted.
Also, if in row 51 I continue adding data, Calc should highlight such cells whenever the data just entered have already been entered in any four horizontally adjacent cells in columns A to D above.
I’m trying to achieve this using Conditional Formatting (Format > Conditional > Condition
, is duplicate
), but keep failing: all I can do is to have Calc highlight duplicates that are found within a column, but not those that are found across several columns. AutoCalculate is enabled.
How can I achieve what I need with conditional formatting?
(I have already found a way to find such duplicates with a formula, but using conditional formatting would probably be easier – if it works at all, that is.)