How do i auto-update an Excel auto-filter (filter by colour) when the colour of cells is changed?
Use case: I change the colour of one cell to the colour that was filtered. I want to see the current row disappearing without having to do anything else.
i was able to use VB given for the value-change-row-disappearing case from: How to I auto-refresh an Excel auto-filter when data is changed?
but don't know how to make it work for colour case. tnx.