c# - Cells format event/hook -

i worked on vsto c# excel 2013. tried , searched many approaches find way trigger more events.

one of important events need is, cells formatted event (changing background color, merging cells.

is there way?

there no such event. main events workbook , worksheet objects. intellisense presumably giving them you. if not, check out ms reference worksheet events. there similar list workbook. these same events available within vba editor inside excel.

if want cheat , make event, involves watching of cells , detecting change using worksheet_selectionchange event. see related: how detect changes in cell format?

note approach not work if trying detect format changes effected code instead of user (unless of course using select in code inadvisable).