LinkBack URL
About LinkBacks
No, that doesn't work at all. It allows all values. Wouldn't you need to use an IF statement?
No, that doesn't work at all. It allows all values. Wouldn't you need to use an IF statement?
no dont need an of
data validation works on the formula resolving to TRUE
so the AND statement will be true only if two conditions are met in the AND
and as one is "fail" - then its only TRUE when you have "fail" in the cell
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Oh. I apologize. I just retried it and it works now. Thank you so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks