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!
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!