Find a value in a range that is larger than any other by 10 or more

[Dwise85]

Hi, can someone help me with a formula that will find a value if the gap between numbers is greater than others in a range by “10” or more.
Eg

Column A
106
93
82
68
124. - highlight green
94
77
79
94

 

[on3moy]

Conditional Formatting.

Use a formula to Format.
Eg. A2>=10, This applies to the range of numbers you highlighted.

 

[Dwise85]

Awesome thanks = )

 

[jtakw]

Hi,

Maybe I'm misunderstanding OP, but wouldn't the formula in Post # 2 just highlight All numbers 10 and higher ?

Assuming your data starting at A1, select A2 all the way down.
CF, use formula, enter:

=A2-10>=A1

Choose Format, Format Fill, Green.

Book1
	A	B
1	106
2	93	FALSE
3	82	FALSE
4	68	FALSE
5	124	TRUE
6	94	FALSE
7	77	FALSE
8	79	FALSE
9	94	TRUE
Sheet609

Cell Formulas
Range	Formula
B2	=A2-10>=A1

 

[on3moy]

Yes, Jtakew is right. I misread question.