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?