How to high-light consecutive numbers in cells

[AMANZ]

I have a series of numbers in 10 columns. Would like to highlight cells that have consecutive numbers even if the numbers are not in adjacent columns.

For example, numbers 8 & 7 and 1 & 2 should be high-lighted

A B C D E F G H I J
4 8 2 10 7 1 12 20 30 15

Any suggestions?
Thanks!

 

[kieran]

Assuming that the listin is in a1 to j10, thy the following formula as a conditional foramt in a1 and copying the format to the whole of the range.

=OR(NOT(ISNA(MATCH(A1+1,$A$1:$J$1,0))),NOT(ISNA(MATCH(A1-1,$A$1:$J$1,0))))

Remember to set the highlight type when you enter the conditional format.

 

[AMANZ]

Kieran, you are a genius

 

[Peter_SSs]

Maybe this?

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1	4	8	2	10	7	1	12	20	30	15
2	7	12	38	5	7	33	28	22	17	17
3	10	44	3	12	46	40	42	5	6	38
4	15	45	7	46	33	16	40	39	36	46
5	3	45	50	23	26	29	23	30	14	11
6	21	15	23	17	5	43	12	15	19	35
7	47	48	12	29	34	23	35	15	49	46
8	25	12	5	3	37	47	35	45	50	7
9	8	9	7	2	5	6	1	3	4	10
10	23	13	44	35	9	48	11	39	50	1
Consecutive Numbers

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	1. / Formula is =ISNUMBER(MATCH(1,ABS($A1:$J1-A1),0))	Abc

 

[kieran]

Peter,

I think your solution is far more elegant.

 

[AMANZ]

Thanks Peter... It gets better. Something for me to learn from

Have a great weekend!