Conditional Formatting Formula

sarahrosenberg

Board Regular
Joined
Aug 27, 2002
Messages
190
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?? :biggrin:

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!
 
Last edited:

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

VBE313

Active Member
Joined
Mar 22, 2019
Messages
431
Office Version
365
Platform
Windows
IF(AND(ISERROR($I$3),$J$3=“*Venmo*”),1,0)
 

Tetra201

MrExcel MVP
Joined
Oct 14, 2016
Messages
3,490
Try applying the following CF rule:

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

Forum statistics

Threads
1,089,274
Messages
5,407,324
Members
403,134
Latest member
fmlp

This Week's Hot Topics

Top