Column E is the issue here.
- If any of Cols A-D have an entry, force an entry in Col E.
- Col E has validation for I or F, but Excel is permitting lower case i or f as well.
- Col F and G are working OK.
Thanks for helping.
Column E is the issue here.
- If any of Cols A-D have an entry, force an entry in Col E.
- Col E has validation for I or F, but Excel is permitting lower case i or f as well.
- Col F and G are working OK.
Thanks for helping.
Last edited by gdstuart; 05-21-2020 at 05:39 PM. Reason: Prompt and creative assistance! I really appreciate the help.
Forcing an entry into G
Excel can't force an entry into G except through VBA. IF you want them to make the entry into G before entering anything in A:D, that's possible with Data Validation but not the other way around. You could also use Conditional formatting to make the whole row Red until G is filled in (if there's something in A:D)
Capital I or F in E
You can go to Custom Data Validation and use this formula =OR(EXACT(E5,"F"), EXACT(E5,"I")) but you will lose your dropdown menu. Again, the way around that would be with VBA if you want.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks