Consecutive numbers

[Sparky]

I have a column with 25 consecutive numbers, example 1 to 25. How do I highlight a cell or cells if someone changes one or more of the numbers in the column and breaks the succession? Example, if the numbers 1 to 25 are in cells A1:A25 and someone types the number 32 in A1 I need A1 to be highlighted as in conditional formatting.

 

[stevebausch]

Why aren't you locking the numbers you don't want changed?

 

[Sparky]

Stevebausch
Before I go on the sequenced numbers 1-25, 25-50,51-75 etc represent car parts. Sometimes the part is not required because the car that it is to be fitted to is not available. Therefore the part number needs to be removed from the sequence, and at a later date the part number will be re-entered when the car is available for the part to be fitted.
I do not need the cells to be locked to prevent change. The fact of the matter is that sometimes the sequenced numbers need to be changed or deleted, I just need the cells to be highlighted to alert individuals so as mistakes are not made.

Thanks

 

[Sparky]

Yogi

Is this a lost cause or is it possible?

Thanks anyway

 

[bolo]

The entries are numbers, I tried your fix anyway and it filled the range K3:K27 with the colour red.
The first sequence of numbers 1-25 with the CF formula =E3<>ROW(E3)-2 works OK.
The second sequence of numbers 26-50 with the CF formula =K3<>ROW(K3)+23 works OK.
The third sequence of numbers 51-75 (Q3:Q27)
I am lost.
Altogether I have 18 lots of sequenced numbers starting at E3:E27 and ending at DC3:DC27 (426-450).
Any further suggestions appreciated

Basically you need to modify each columns CF by 25. notice the following pattern for the CF:
Col E = row -2
Col F = Row + 23
Col G = Row + 48
Col H = Row + 73
etc

Hope this helps you

 

[bolo]

The entries are numbers, I tried your fix anyway and it filled the range K3:K27 with the colour red.
The first sequence of numbers 1-25 with the CF formula =E3<>ROW(E3)-2 works OK.
The second sequence of numbers 26-50 with the CF formula =K3<>ROW(K3)+23 works OK.
The third sequence of numbers 51-75 (Q3:Q27)
I am lost.
Altogether I have 18 lots of sequenced numbers starting at E3:E27 and ending at DC3:DC27 (426-450).
Any further suggestions appreciated

Basically you need to modify each columns CF by 25. notice the following pattern for the CF:
Col E = row -2
Col F = Row + 23
Col G = Row + 48
Col H = Row + 73
etc

Hope this helps you

 

[Sparky]

Bolo

Something so simple.
You're a star

Topic closed
Thanks to everyone who took time to look at the post.......Brilliant message board

 

[Yogi Anand]

Hi Sparky:

Sorry, I was away from the Board for the last few days, and missed the great throw by Bolo, but you made the winning catch -- you are the Star. So, you see when we have faith in the team, it is never a lost cause.

Regards!

Yogi