Hello all,

I have been desperately searching for a way to make this work but can't figure it out for the life of me. I was hoping that someone could help me!

I want to say, basically,

if cell e2 is like "*whatever*" then cell e4 should be "15" if not then highlight the cell.

I want to do that for a whole range so I know that I'm going to need a loop for it.

Any thoughts?

Thanks!