Bright01
asked on
Validation of Data Formula in Excel
EE Pros,
I'm trying to place "validation" on a particular cell that looks at a "merged" cell and if there is content (e.g. a number) then it issues a Warning. I know how to use Data Validation and thought this was the easiest way.....however, I don't know the formula.
I've tried =if(G4<>" ") and (G4<>"") but neither work.
Here is a diagram/sample.
B.
Validation-Warning.xlsm
I'm trying to place "validation" on a particular cell that looks at a "merged" cell and if there is content (e.g. a number) then it issues a Warning. I know how to use Data Validation and thought this was the easiest way.....however, I don't know the formula.
I've tried =if(G4<>" ") and (G4<>"") but neither work.
Here is a diagram/sample.
B.
Validation-Warning.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You welcome, glad it was helpful.
ASKER
B.