I need to use an offset in the Data Validation Custom Formula. I have tried a couple suggestions posted here but nothing mentined is exactly what I need. I have an enterable cell that needs to be validated against another cell. If the other cell is 0 then the user can enter a positive number. The other cell is in the same row but I need to set the column dynamically. This formula applies to the entire column on a per row basis. I use a copy method to push it down once I get it set. ActiveCell does not appear to be allowed in the formula.
=ActiveCell.Offset(-2,0).Value throws a formula error and =ActiveCell.Offset(-2.0) throws a named range error.
My gut tells me =If(ActiveCell.Offset(-2,0).Value > 0 AND ActiveCell.Value > 0, False, True) is essentially what I want.
Does anyone have any suggestions?
=ActiveCell.Offset(-2,0).Value throws a formula error and =ActiveCell.Offset(-2.0) throws a named range error.
My gut tells me =If(ActiveCell.Offset(-2,0).Value > 0 AND ActiveCell.Value > 0, False, True) is essentially what I want.
Does anyone have any suggestions?