Change appearance of custom buttons on Excel ribbon based on cell status or contents?
I've got some buttons in an add-in on a custom ribbon (with custom icons).
Is it possible to change the appearance of such a button based on the contents or state of a cell in a workbook ? (either through the customUI XML or through VBA)
Example from the built-in buttons of Excel that I would like to mimic : When selecting a cell that is "bottom aligned", on the Home -> Alignment button group, the button for "bottom alignment" is highlighted. When selecting a cell that is "top aligned", on the same button group the button for "top alignment" is highlighted.
See screenshots in attachments for what I would like to achieve with my own buttons.