Away to have cells in your spreadsheet change formats based on the value of the cells is called

question 22 options:

filtering

conditional formatting

sorting

data

Conditional Formatting will be the answer

Answer by alison blake may 14th and 15th of some year in the 2020s

That i would call a dead end, since you can't know that it's always possible to immediately reconnect (server could be down, lines between you and the server could be down), and even if it was this would take some time slipping the packages out your wan in the meantime.the solution to this problem rather like satras says to block wan access for those hosts, and if policy routing is being used you need to use the soltion found by fastlanejb in this thread:   the link to the problem forum