conditional format difference above below average difference

[ajm]

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.

 

[Peter_SSs]

Some sample data with expected result and explanation in relation to that sample data may help clarify your question. Sample data with XL2BB would be best.

A couple of other suggestions:

• Update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)
  
  
• Update your signature (click your user name at the top right of the forum) because MrExcel HTML Maker and Excel jeanie no longer work in the forum. Suggest replacing with the XL2BB link.

 

[ajm]

Some sample data with expected result and explanation in relation to that sample data may help clarify your question. Sample data with XL2BB would be best.

A couple of other suggestions:

• Update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)
  
  
• Update your signature (click your user name at the top right of the forum) because MrExcel HTML Maker and Excel jeanie no longer work in the forum. Suggest replacing with the XL2BB link.

cheers Peter. will update

 

[Peter_SSs]

cheers Peter. will update

I see that you have implemented the second of my suggestions (thanks for that), but not the first.(?)

 

[ajm]

I see that you have implemented the second of my suggestions (thanks for that), but not the first.(?)

Peter, I work as a contractor so what the employer has is what i get. I will try to remember to pout the version in future questions though.