sorry, I thowght = 9 (number) hold on
"filo666" wrote:

1.

bla bla bla

for a=YourFirstRow to YourLastRow
if cell(a,NumberOfColumn)=9 then
WhateverYouWantExcelDoWhenIfStatementIsTrue
else
WhateverYouWantExcelDoWhenIfStatementIsFalse
End if
Next

more blablabla
HTH

"Nina Hibbler" wrote:

Okay...

1. Check cells withing column 1 to make sure character length is exactly
= 9.

2. Entries in columns 2 an 3 are to be centered, 1 character in length,
are to be in all caps and can only be certain characters (i.e. A, C, H,
O).

3. Column 4: 3 characters in length, all caps, are limited to type for
example, ABC or DEF only.

4. Column 5: all caps.

5. Column 6, 7 & 8: these are dates and must be formatted mm/dd/yyyy.

This is the basic details of what I'm trying to accomplish because
sometimes I have a lot of information to look at it and my eyes may not
be the best to rely on. Plus, writing code makes a task like this
easier.

I also want to know if something like this can be put in place so if I
were entering fresh data into a sheet that didn't match the preset rules
...an error message would display...

*** Sent via Developersdex http://www.developersdex.com ***