Conditional Formatting

[hamhead69]

I have a spreadsheet I'm using to track a March Madness pool. I'm trying to format a cell based on whether or not another cell contains that value or not.

Example;

D56 contains the text "Louisville vs. Oregon". I want to check the value of cell F56 to see if Louisville or Oregon is contained in it. If it is I don't want to change anything. If it isn't I would like to change the font effect to strikethrough.

I'm a pretty basic Excel user so I'm hoping someone on here can assist.

Thank you!

 

[Andrew Poulsom]

Try the conditional formatting formula:

=ISERROR(SEARCH(F56,D56))

 

[hamhead69]

It worked perfectly. Thank you very much.