did you see my edit above? changed the formula to use SEARCH, instead of MATCH. It works on my end.
- Moo
Adjusted formulas:
Condition 1 (Set to 'Stop if TRUE'): =ISBLANK($L2)=TRUE
Condition 2: =OR(ISNUMBER(SEARCH("@",$L2)),ISNUMBER(SEARCH(".",$L2)))=FALSE
Bookmarks