Data Validation

[dadrew]

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?

[Søren Larsen]

You use =$G$2 instead of =G2 in your data validation.

[dadrew]

You use =$G$2 instead of =G2 in your data validation.

Superb answer, many thanks!

[Søren Larsen]

EDIT: Delete