Adding Date Data Validation to cells with List Data Validation
I've created a spreadsheet wherein cells are manipulated via a dynamic drop down list. This is accomplished using the "List" data validation type. What I'd ultimately like to do is restrict users from manipulating cells (or, more accurately, entire rows) past a certain date. I know this may be accomplished via the "Date" validation type, however, I am unable to understand how to include more than one data validation type per cell.
Is it possible for me to somehow restrict editing of an entire row based on any given date, if each cell in said row already contains one type (List) of data validation.
To be clear, I would like the cells in row 1 to "deactivate" & not be manipulated after, say, September 9; then, for Row 2, I'd like the cells to deactivate on September 16th; and so on. I do not need a set range as much as an end date, though set ranges could work also in a pinch.
Thanks a million, said the new guy.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By Pheasant Plucker® in forum Excel General
Last Post: 09-18-2018, 08:49 AM
By movali01 in forum Excel General
Last Post: 07-03-2014, 02:37 AM
By anonDymous in forum Excel General
Last Post: 03-12-2013, 02:18 PM
By POC in forum Excel General
Last Post: 07-23-2006, 12:45 AM
By StargateFan in forum Excel General
Last Post: 02-02-2005, 11:06 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1