Checking that a cell has an address in it

[mateinone]

Hi
So I have been trying to work out a problem
I have cells that have address in them and we have another tool for geocoding, so we need these addresses to be in a standard format
So I want to basically conditional format to turn the cell red or something if the cell data is not entered correctly.

street number, street name, street type

for example

16 Anywhere Road

If is it
1/16 Anywhere Road, that needs to fail

There is another field for units/shop numbers etc.

So I figured one 'easy' way would be to check the first field is a digit, and check the last field is a type of a road.
The issue is ensuring the middle word(s) have letters in them.
I can't think of a street with only numbers in it, but there are streets with numbers and letters, for example 23rd street.

Anyway if anyone has a suggestion that can help here it would be much appreciated. I hope what i am looking for is clear

Thanks in advance

 

[Alice Morland]

Hi Mateinone,

How about you check for special characters? So if an address has %, #, * etc, it turns red? You're right, the street names could include numbers.

Alice