MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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 doesn’t 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)<>"\"