freshgoblinmilk
New Member
- Joined
- Nov 7, 2022
- Messages
- 6
- Office Version
- 2016
- Platform
- Windows
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.
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.