Forum Discussion
Data validation to multiple cells
Hello I have an excel sheet that currently has multiple cells filled with data etc and I’m trying to setup a data validation so that in specific cells only data that can be entered is the date a...
You can't "apply" or "extend" the existing format to those other cells but you can select all the cells you want the data validation to be applied to and then hit data validation. Enter the formula the same way you would enter a conditional formatting formula. For example if you select the entire column A then enter it as =OR(ISNUMBER(A1),A1="ASAP")
if you select C2 down and right to E1000 then C2 was the upper left selection and you use C2 in the formula.
Hope that helps