Forum Discussion

Rushy1's avatar
Rushy1
Copper Contributor
Mar 03, 2025

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 as this DD/MM/YY or ASAP I have managed to set this up for one cell on its own but with this data validation formula

=OR(ISNUMBER(Cell),Cell=“ASAP”) 

 

is there a way to apply this to all the cells I want without having to manual change cell to each individual cell I want it applied to as the excel sheet has over 3000 cells with data in it and without having to delete the current data in those cells 

 

excel
  • m_tarler's avatar
    m_tarler
    Bronze Contributor
    Mar 03, 2025

    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

Resources