I have two validation cells that refer to the same range.
However, when you select a number in the first cell, I want the second cell
to only show numbers equal or higher than the number selected in the first
cell.
Do I need two ranges? How can I create a range that equals or is higher than
the number selected in the first cell?

Example: I have a range named GOLD with a range of 30 - 70.
The users selects 40.
When the user selects the 2nd cell, I want the range to only show 40 - 70.

Any help would be appreciated. Thanks!