Hi,
Is it possible to setdefault value using data validation.
I have 3 values not done,done ,ignored in data validation. i want 'not done' to be the default value. how to do this. im using this in Conditional formating to check the condition
Before applying the data validation, you can enter a formula into the cells to show the default value when the row is active. Let's say the key column is A, when you start filling out data in column A, this default value should appear.
First, enter a formula like:
=IF(A2="", "", "not done")
Copy that down your column.
Now apply the data validation to the same cells.
Anytime you start a row, "not done" will appear, but you can use the DV drop box to change the value. When you do, the formula that was there is now gone for good.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
HI
Thanks for your reply . can i use combo box instead.
I it possible to check the status of this column in conditional formatting then hw to do it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks