Copying custom validation formula

[dlsminnie]

I created a custom formula in Data Validation and it works great. My issue is I need to copy that exact validation to over 10,000 cells.

Example:
Validation is Custom
Formula: =IF(B5>=500,TRUE,FALSE)
No Input Message
Error Alert Stating Not Eligible for Promotion until minimum of $500 is met.

Need this exact validation to be in each cell of column C rows 13 through 10,000

I tried to copy, paste special, validation only and tried to drag the formula down - it copies the formula but increases cell B5 to B6 and so on for each line. I would have to Is there a way to mass copy/paste this exact formula to all the cells without having to touch all 10,000 cells??

Thanks for any help!!

 

[Alex Blakenburg]

It is the same as for normal formulas, just make the B5 absolute ie $B$5 before copying it.

I don't really understand your validation since it only makes sense if the cell in which you are entering data eg a cell in the range C13:C10,000, is part of the formula in B5.

 

[dlsminnie]

Thanks! This worked great. The ranges I listed above were just examples. The spreadsheet is large and I just used small letters instead of using AO5 and AC13:AC10000.

 

[Alex Blakenburg]

Thanks for letting me know. Glad I could help.