Directory Validation
Posted by Paul on April 24, 2001 12:06 PM
Does anyone know how to write a macro or set validation on a cell to make sure the what is in a cell is a valid directory. i.e. Ends in a \. The directory doesnt need to exist.
Thanks
Posted by Anon on April 24, 2001 4:47 PM
Conditional formatting.
Formula is :-
=RIGHT(A1,1)<>"\"
or
=OR(0,RIGHT(A1,1)<>"\"
