Is it possible to have a if condition with data validation...
So I have a list in data validation against a named range in the source field....=Projects...
I want to amend so that if cell G7 is blank then make H7 blank and not show current project name that was pre selected form the data validation list....
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.