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
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)
Bookmarks