Error Message for Data Validation

[jrandol]

I have two validation criteria in a cell (B18) that say:

H17 must be filled before B18 can be filled
and B18 has a text length limit of 45

The code looks like this: =AND(LEN(H17)<>0,LEN(B18)<46)


What I am needing to know is if I can have a different "error message" pop up for each criteria. I would like to have a message pop up if cell H17 isn't filled and if their entry into B18 is more than 45 characters.

If this is possible, I appreciate the help!
JR

 

[Aladin Akyurek]

That formula should be:

=(H17 <> "")*(B18 <> "")*(LEN(B18) < 46)

I don't think data validation allows for separate messages...

 

[Zack Barresse]

you'll only get one error message for any criteria selected being met.

you could always try to do something in vba though, not my suit though.

 

[jrandol]

Thanks for the info! I figured that I wouldn't be able to have seperate messages, but thought I would ask. I also don't want to get into the VBA.

Thanks!
JR