I have an Automation that is triggers when a column is updated. However, this only works when one cell is changed at a time. When multiple cells in the column are deleted, or when dragging a value down to copy/fill the column, or when pasting a value into multiple cells, the trigger is not activated for any of the cells.
Note: you can test this in my shared “Construction Schedule” workbook. I’m using my own [% Done] column instead of the Progress column because I want the colors of the bars to match exactly the colors that I’ve chosen in the Color column (by making the progress 100% by default). When I enter 100% in my [% Done] column, the automation changes the color of the bar to Gray (because I want all of my completed tasks to be gray).