Autofill for Custom Validation in Excel 1

[Tony220]

I have created a custom validation in cell C17.

if(B17=Bank) AND if(C17=1)

This requires the corresponding cell in column B to read "Bank" and if it does then this cell will accept only one entry and that is the number 1.

I would now like to auto fill this validation so that each row will have the same validation that is appropriate for that row.

Ex. in cell C18 " if(C18=Bank) AND if(C18=1) "
and so forth.

When I drag now it just copies the validation formula rather than substituting the appropriate row number.
If there is no way to correctly auto fill the validation is there another way to accomplish what I am trying to do.

Thanks a load.

 

[SkipVought]

Hi,
[tt]
=AND(B1="Bank",C1=1)
[/tt]


Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}