Conditional Formatting Formula

[sarahrosenberg]

I need to write a formula that highlights cells that contain an error if the next cell contains the word "Venmo."

IF (AND (I3=ISERROR , J3 CONTAINS THE WORD VENMO)) then color the cell red

I know my formula is silly, but think it conveys what I am trying to do??

TIA!!!

Sarah

PS, I know how to access the tab to create conditional formatting formulas, I just can't figure out how to type it!

 

[VBE313]

IF(AND(ISERROR($I$3),$J$3=“*Venmo*”),1,0)

 

[Tetra201]

Try applying the following CF rule:

=AND(ISERROR(I3),SEARCH("Venmo",J3))

 

[sarahrosenberg]

This worked perfectly. Thank you so much!!