Under Tools>Customize…>Keyboard there is an action for Manage Conditional Formatting. I can assign it to a keystroke. But I have not been able to have any keystroke so assigned actually do anything. I can do Manage Conditional Formatting from the Format menu or the toolbar icon.
Am I missing something? Is Manage Conditional Formatting just not the dialog I think it is?
I’ve tried oldest and master in the LO v24.8 bibisect repository with the same results.
It seems that you have to call the dialog, Manage, which lists all the conditions in the sheet before selecting the relevant condition in the dialogue
I also cannot get the Manage Conditional Formatting to do anything, even selecting the conditional range. With the range selected then Conditional Formatting calls the dialogue for those conditions.
Try assigning a keyboard shortcut to a macro that calls the above dialog:
Sub CallConditionalDialog()
Dim document as Object
Dim dispatcher as Object
document = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
dispatcher.executeDispatch(document, ".uno:ConditionalFormatManagerDialog", "", 0, Array())
End Sub