For instance, if you create a conditional formatting rule that highlights cells with values over 100, and one of the cells in your set changes from 95 to 102, that cell will become highlighted.