Dear Expert,
Do you have any idea how to get a data validation without using list?
Just using Pass/P or Fail/F
For example,
Column A Column B
Report 001 PASS/P
Report 002 FAIL/F
Hope to hear from you soon.
Thanks.
Dear Expert,
Do you have any idea how to get a data validation without using list?
Just using Pass/P or Fail/F
For example,
Column A Column B
Report 001 PASS/P
Report 002 FAIL/F
Hope to hear from you soon.
Thanks.
If you want to restrict entry to either Pass or Fail, 1st select List under Allow, then for Source, enter "Pass", "Fail"
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi FDibbins,
Thanks for your reply.
It is a normal to use a list as data validation. How do I use data validation without using the list under Allow, but just key in PASS or P / FAIL or F?
Hope to hear from you soon.
Is it are you looking for?
Quang PT
Dear bebo021999,
Thank you very much for your amazing reply.
Yes, this is what I am looking for.
Nice to hear it works.
Anyway, without dropdown list, users may confuse because they dont know what to type in that cell.
Dear bebo021999,
Use Input Message at the data validation for each cell.
Dear bebo021999,
Too happy until i have a small query.
How to fix the only this format "Pass" or "Fail" rather than this format "PASS" or "FAIL"?
Thanks.
EXACT will help :
=OR(EXACT(B2,"Pass"),EXACT(B2,"Fail"))
Dear bebo021999,
That is so good. Finally.
Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks