I want to write a condition like, if the A1 cell contains "some values" then the cell B1 should get disabled (user cannot give input in the cell B1).
Is this possible..?? Please help me with this..
I am very curious to know and its very urgent for me..
Thanks in Advance..
click B1
go to ->Data ->Data Validation -> custom
formula
=A1=""
if A1 has value B1 will not accept any entry..
is this what you want?
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Not exactly.. like
In the column D, the user will select a value from a list (which is a dropdown which contains a data in a list). If the user select the value as "Click" in D1 then the cell E1 should be disabled. and If the user selects the value as "Clear" then the cell E1 and F1 should be disabled.
So that each values in the list has some conditions.
And also the disabled field should be blurred so that the user should understand this cell is disabled and he cannot enter any values in it.
Something like this?
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
Hi ChemistB
Exactly the same.. Thanks for understanding.
@ shaal
Welcome to the forum.
Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.
Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
Hi Cutter,
Actually my problem haven't got resolved yet.
Mr. ChemistB have pointed out what my expected result should be. But I haven't got the solution for it.
So, It would be very helpful if someone answer for my query and the thread gets resolved.
I am waiting for the reply. Please do the needful.
You'll need to do data validation and Conditional formatting.
In Column E
Data Val: =AND(D1<>"Click", D1<> "Clear")
Cond. Form: =OR(D1="Click", D1="Clear")
In Col F
Data Val: =D1<>"Clear"
Cond. Form: =D1="Clear"
Does that work for you? Any questions?
How to use this..?? Mean where to write this code..??
I am new to these kinda stuff..
Okay, select the first set of cells you want to format/lock. In my example, it is E1:E15
On the Data Tab> Data Validation>From "Allow" dropdown menuChoose "Custom"
Then paste in that formula =AND(D1<>"Click", D1<> "Clear")
Change that if you have headers or your data doesn't start in D1. If your Data, for example, is going to be from D4 to D100, then you would select E4 to E100 and your formula would be
=AND(D4<>"Click", D4<> "Clear")
Then "OK"
With same range selected, on Home Tab> Conditional Formatting> New Rule> Use Formula
and paste in the formula =OR(D1="Click", D1="Clear")
or (for example 2) =OR(D4="Click", D4="Clear")
Then Click on Format button and choose a background color or "pattern style" that you want
Hit "OK" to close windows
Repeat with Column F
Any questions?
Hey Chemist,
Thanks for it.. It was detailed.. I got it..
Hi Chemist
Is there any method in excel to achieve the below concept
Eg. In cell A2 I have added list of values, "A" ,"B" and "C"
Now if I select value as A in A2 cell then I should get the List of values displayed automatically in column B2 as "A1","A2","A3"
or if I select value B in A2 Cell I should get the List of values in column B2 as "B1","B2","B3"
Kindly provide solution for this
Thanks in advance
sowmiya.
Upload an example spreadsheet showing what you have and what results you are expecting to achieve. (Go Advanced>Manage Attachments)
sowmiya91, welcome to the forum
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
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
@ Chemist will try ,thanks for the response
@Fdibbins - sure i will do that henceforth
The attached file was useful. Unable to figure out how to blur the cell if the value should not be entered.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks