Highlights two cells that in sequence

[RichTom44]

Hello Everyone,

How can I able to highlight the entire column where numbers are not in sequence? There are two cells that are in sequence and I want to highlight the one cell that is out of sequence. Thanks

OUT EIR
13079
13080
15111
15112
13150
13151
13192
13193
13138

 

[Peter_SSs]

Welcome to the MrExcel board!

How can I able to highlight the entire column

I want to highlight the one cell that is out of sequence.

The above two requests seem contradictory. One asks to highlight an entire column. The other asks to highlight one cell.

In your sample it seems that you want to highlight the last entry. Is that the case?
If so, why highlight that value when 13150 also seems to be out of sequence?

Please explain better in words exactly what you are trying to achieve.

 

[RichTom44]

Welcome to the MrExcel board!




The above two requests seem contradictory. One asks to highlight an entire column. The other asks to highlight one cell.

In your sample it seems that you want to highlight the last entry. Is that the case?
If so, why highlight that value when 13150 also seems to be out of sequence?

Please explain better in words exactly what you are trying to achieve.

Hi, Thanks for the reply. I want only to highlight the last entry. As you can see in the sample every two cells are in consecutive order and I want to highlight the one cell that has no other pair of consecutive numbers.

 

[Peter_SSs]

Thanks for the further detail. Does this do what you want?

23 10 23.xlsm
	A
1	OUT EIR
2	13079
3	13080
4	15111
5	15112
6	13150
7	13151
8	13192
9	13193
10	13138
CF

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A10	Expression	=AND(A2<>N(A1)+1,A2<>A3-1)	text	NO

 

[RichTom44]

Thanks for the further detail. Does this do what you want?

23 10 23.xlsm
	A
1	OUT EIR
2	13079
3	13080
4	15111
5	15112
6	13150
7	13151
8	13192
9	13193
10	13138
CF

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A10	Expression	=AND(A2<>N(A1)+1,A2<>A3-1)	text	NO

Yes, it perfectly works. Thank you very much...

 

[Peter_SSs]

Yes, it perfectly works. Thank you very much...

You're welcome. Thanks for the follow-up.