Validation of Data Formula in Excel

Bright01
Bright01 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Select cell (E8) Enter this formula in data validation.


=istext(G4)

Open in new window

Validation-Warning.xlsm

Author

Commented:
Perfect!  Quick and effective.  Thank you!

B.
You welcome, glad it was helpful.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial