Sequential numbers between two cell values

[freshgoblinmilk]

Hi all. I have two tabs with same layout as shown here:

The first tab is named "SEQUENCE" and is nice and neat , where the "Start" figure is the previous "End" figure + 1.
The second tab is named "BESPOKE" and is where the customer has chosen specific "start" and "end" figures.

The issue I have is that I need to make sure that none of the figures are repeated, as they are serial numbers being entered on a program. If a number has two entries the program gets confused and kicks out a bunch of errors before crashing.

1) I was thinking a conditional formatting where "if values between BESPOKE D?-E? are shown between anything in SEQUENCE D-E, highlight the row red" but I have no idea if that's even possible.

2) So my next thought was to (in column K) autofill sequential numbers from D to E on both tabs, then do a conditional formatting where "If a figure in BESPOKE K matches a figure in SEQUENCE K, highlight the affected rows red". But then I realised I have no idea how to do that either.

Does anyone have any ideas? I am hoping to avoid macros but will if there's no other way.

 

[JamesCanale]

MrExcelPlayground13.xlsx
	B	C	D	E	F	G	H	I	J
1	Sequence Sheet							Bespoke Sheet
2	S	E						S	E
3	9300	10099						11000	11500
4	10100	10109						10110	10500
5	10110	10509						10967	10972
6	10510	10909
7	10910	10929
8	10930	10949
9	10950	10969
10	10970	10989
Sheet21

Cell Formulas
Range	Formula
B4:B10	B4	=C3+1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B3:C10	Expression	=SUM(($C3>=$I$3:$I$5)*($B3<=$J$3:$J$5))>0	text	NO

 

[freshgoblinmilk]

MrExcelPlayground13.xlsx
	B	C	D	E	F	G	H	I	J
1	Sequence Sheet							Bespoke Sheet
2	S	E						S	E
3	9300	10099						11000	11500
4	10100	10109						10110	10500
5	10110	10509						10967	10972
6	10510	10909
7	10910	10929
8	10930	10949
9	10950	10969
10	10970	10989
Sheet21

Cell Formulas
Range	Formula
B4:B10	B4	=C3+1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B3:C10	Expression	=SUM(($C3>=$I$3:$I$5)*($B3<=$J$3:$J$5))>0	text	NO

Thank you, this works perfectly. You have saved me a massive headache