Change status when a number changed in other column

We would like to have a feature that automate change the status based on a certain changes on other column.

Like the sample below, if “Task progress” value change to ZERO, status will be changed to something, if value changed to ZERO but less than 100, status to change to something, if the value was set to 100, status will be changed to something…