Hello,
I’m trying to change the order of conditional formatting rules in Collabora Online (via Nextcloud), but I can’t find any UI controls to reorder them.
Setup
- COOLWSD version: 25.04.8.3(git hash: 0de01f3f02 (E))
- LOKit version: Collabora Office 25.04.8.3(git hash: 9b4357e5e7)
- Served by: unknown
- Server ID: REDACTED
- WOPI host: nextcloud 32.0.6.1 - richdocuments 9.0.2
The problem
There are two overlapping rules:
- =$B2=TODAY() → should highlight today’s cells (priority #1)
- =WEEKDAY($B2)=1 → highlights all Sundays (priority #2)
When today is a Sunday, rule #2 overrides rule #1 because of evaluation order.
Therfore I want to swap the priorities.
I found a reference to Up and Down buttons in the official documentation: Conditional Formatting .
But I assume that’s only the order of the conditions down in the rule itself?
Question
Sure, I can delete and create the rules, but this seems not very comfortable to redo the work.
Therefore, I would like to ask, if anyone know if there’s an option to change the order of the rules, without deleting and re-creating them?
Would appreciate for help.
Best regards
Simon