Is it possible to apply individual data validation formulas to many cells quickly perhaps through VBA or otherwise?

[Rnkhch]

Hello,

I had already applied validations to 400 cells before, but I just figured how to enhance it with restrictions/error messages, and now I'm hoping that there is a way that I can put in the 400 new validation formulas in a batch at once, perhaps by writing them in a column and indicating which cells they would belong to in the adjacent column and run a VBA code. Would something like that be possible? If so, it will save me an enormous number of hours

Thanks for any input!