Dear experts
i have set of data i want make data list option to be selected on 3 column B:B,D:D,F:F
other than these values , any values cannot be enter in the cell.
i want make protection of range with these values only except i want use formulas in that range if formula result is not same in data validated list , should result get error msg.
RESPONSIBILITY
OWNER
STATUS OF CALL
PLS FIND THE ATTACHMENT
Hello breadwinner,
Would the attached WorkBook, work for you?
Also see the "Please consider" note at the bottom of this post.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Hi
You can use Data Validation with an error message. You dont need a VLOOKUP formula.
Tony
thanks alot its works
Its locked only for 2 columns but
I want Make error alert for 3 column with list of values.
make it apply to this sheet
this is my master sheet.
Hello breadwinner,
Is this how you want it then?
Hi
I have added an error message using Data Validation to your third column.
See attached workbook.
Good luck.
Tony
@ ARGK,
Thank you Tony, but I have already done that in the WorkBook as per Post # 2, and again in Post # 5.
From the TimeStamp of our last two Posts, it would appear that we were having a go at it, at more or less the same time.
Thank you for helping here as well.
Dude!!! HERE ONLY FOR BC ONLY I want apply error alert for 3 columns APPLY TO "AY" "BA" "BC" ALERT
PLEASE ONCE AGAIN
Hello breadwinner,
This is the best I can do, with what I understand you want.
Hope that helps.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks