LibreOffice has a Manage CF dialog that holds multiple, not necessarily related entries of CF. The actual Add CF dialog allows to define multiple conditions, all related to one range, in a non-standard UI. Excel does not allow those combinations. The whole workflow needs to be scrutinized and the concept challenged. Some issues: * the Manage CF dialog lacks of sorting (bug 105325) * shows only a single condition without any indication of more (bug 164325) * does not show the formatting * could be improved by toggles to activate CF (bug 101553) * the Add CF dialog becomes difficult to manage with growing number of cell value options * hides the formatting when switching to another condition * allows strange combinations of all cell conditions and cell values One potential solution is to "flatten the workflow" and to allow only one condition per Add CF. This simplifies workflow on cost of flexibility, in particular thinking of a toggle to activate a (combination of) CF. The opportunity to (re)unify CF has been requested before (bug 87274) and could be done in the Manage CF dialog only. As for the Manage CF dialog I'd suggest to switch from the listview to a treeview and show all information when expanded.
Created attachment 199107 [details] Excel's Manage CF dialog MSO 365 on macOS Version 16.93.1 (25011917)
Created attachment 199108 [details] Example document Some numbers with CF
@Heiko, do you want to merge "CF Manage" dialog with "CF for" dialog?
(In reply to Roman Kuznetsov from comment #3) > @Heiko, do you want to merge... It is an option to discuss.