I am trying to do some Data Validation on a column. I have selected a cell "D3" and have set the criteria as follows:
Allow - WHole Number
Data - Between
Minimum - 0
Maximum - =G2 (this is a cell that has a number currently 20 but it can be changed by the user)

My problem is that the cell works fine but I want to apply the same rule to the whole column. When I select the cell handle and drag downwards, the validating is applied, but rather than the Maximum being =G1 it will choose the next cell i.e G2 then G3 and so on.

How do I overcome this please?