In Column A I have various entry option in each rows - "F","O","I","P".
In Column G depending on the selection I need a different data validation option/list to be available.
If A6 = "O" then G6 = numeric validation 0000
If A6 = "P" then G6 = "Not Signed","Signed
Each row in G might have 5...