Checking that certain cells contain specific numbers

My job uses a lot of C-cans which are labeled as 4 letters followed by 7 numbers, and contain different material inside them that is also numbered.
On the packing slips I generate for this cargo it is very important to not have any mistakes - so I had help making a macro to turn cells RED if they didn't contain the correct info ie."4 letters followed by 7 numbers". (See below for the Can# check)

Please Login or Register  to view this content.

I'd like to do something similar for multiple other boxes. Some things to add are:
1) Cell C5 must contain the text "Shipment #" followed by 2 numbers [0-9]{2} example: Shipment # 02
2) Cell C7 must contain the text "Seal # UL-" followed by 7 numbers [0-9]{7} example: Seal # UL-1234567
3) Cell G5 must contain the date in format of 11.11.11
4) Cell G6 must contain 8 numbers followed by a "-" then 2 numbers example: 12341234-12

5) Then cells B18->B26, F18->26, G18->26, and G38 must contain at least 1 number.

I've tried tackling this on my own - for instance for #1, with stuff like:

Please Login or Register  to view this content.

but I'm not so familiar with how these things work, or where I should be copy and pasting that code to. Ie. within the sub of the last macro? on a new one with the option explicit text again? etc.
(Attached a blank copy of the form I'm using)

Any help would be greatly appreciated!! Thanks in advance

What's the use of a blank file to help you?
I'm not going to fill in data,

Thanks, I'll take a look, is bed-time here so won't 'til tomorrow

Since you're still awake

Try this.

Please Login or Register  to view this content.

Good-night

Originally Posted by ReganK

I'd like to do something similar for multiple other boxes. Some things to add are:
1) Cell C5 must contain the text "Shipment #" followed by 2 numbers [0-9]{2} example: Shipment # 02
2) Cell C7 must contain the text "Seal # UL-" followed by 7 numbers [0-9]{7} example: Seal # UL-1234567
3) Cell G5 must contain the date in format of 11.11.11
4) Cell G6 must contain 8 numbers followed by a "-" then 2 numbers example: 12341234-12

5) Then cells B18->B26, F18->26, G18->26, and G38 must contain at least 1 number.

Any help would be greatly appreciated!! Thanks in advance

Try

Please Login or Register  to view this content.

Well, now's the time to set the grey matter to work and try out yourself, you've got the code, Jindon's is the best one, all you need now is the extra conditions and you could even do that with conditional formatting.

Just holler if you get stuck

Off to bed here.

Originally Posted by ReganK

IF B18 has contents, then F18 and G18 must as well. (Could be in any order)
ex. if F18 has contents then B18 and G18 must as well, etc.
Similarily: if F17 has contents then B17 and G17 must as well

ie. If i have any info across the slip then I must have all the info
Item # / box / weight

See if this is how you wanted.
Edit:Missed col.B and fixed.

Please Login or Register  to view this content.

Even though it was marked solved ....
For some reason I couldn't get Jindon's code to work so I took the liberty of editing it and it looks like it's Okay now.
Excuse the intrussion