hi, has anyone got a conditional format formula that will help me highlight if the difference between a new number in my range and the last number is more than 50% higher than the average difference for the range? For example, say the average differences between several rows of data in a single column of data is 50. If i were to enter a new number in the range that results in the difference between it and the number in the previous row that is higher than 50, the conditional format would be triggered.