Hi I'm trying to apply some data validation to a column, i've got it working as a true false,
Please Login or Register to view this content.
but when I try to use it for data validation it doesn't work, and I can't see what's wrong.
8 AM 2 10 AM TRUE
12 PM 5 5 PM TRUE
10 AM 3 1 PM TRUE
2 PM 1.5 3 PM TRUE
2 PM 3 5 PM TRUE
4 PM 1 5 PM TRUE
58 10 AM FALSE
12 AM TRUE
I've put the formula in a column just to show true false are correct but want to use it in validation on the Hours column,
the workbook's attached and will show things more clearly. the validation is being (or not ) to C5 :C12 .
Richard.
Bookmarks