Hi, try this
For column A, first select the cell or cells you need to be restricted
then go to Data/Validation and select Custom from the Allow menu, in
the formula box type:
=UPPER(A1)="ACTUALS"
A1 being the first cell in your selection, then click on the Alert tab
and type your message or warning, click Ok
For column B the formula would be something like:
=LEN(B1)=6
or if the account number contains only numbers and no text then:
=AND(ISNUMBER(B1),LEN(B1)=6)
as for the other 2 I don't know, maybe someone else has some ideas.
Hope this helps!
JG
--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile:
http://www.excelforum.com/member.php...fo&userid=6261
View this thread:
http://www.excelforum.com/showthread...hreadid=473003