Hello,
i have data validation in a col and based on that i want the cells to lock. the problem is that i need to have the formula too. Please see attached, locking of only grey cells in the attached.
Hello,
i have data validation in a col and based on that i want the cells to lock. the problem is that i need to have the formula too. Please see attached, locking of only grey cells in the attached.
1st, you cannot have data validation AND a formula in the same cell, it is 1 or the other.
2nd, (have not looked at your file), but if you want other cells to not allow entering, depending on if the DV has something in it, then you need to apply DV to those cells
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
no, DV and formula not in the same cell
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks