Conditional Data Validation?

Topics: Developer Forum, Project Management Forum, User Forum
Nov 2, 2011 at 1:58 PM

I'm trying to figure out how to validate a cell based on the value in another cell.

Basically, if cell A.ActiveRow <> "" G.ActiveRow cannot be empty.

If the user hasn't put anything into the A cell of a specific row, then the G cell of that same row can be blank.
But if they have put some value into the A cell of the specific row, then they must enter something (any text is fine) into the G cell of that same row.

Is there a way to do that?