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?? :-D
TIA!!!
Sarah
PS, I know...