Hi everyone,
I am trying to italicize a cell (B7) based on if the letter S is anywhere in C7.
I have already tried the formula $C$7="*S*", but this doesn't work.
Does anyone know how to do this?
Thanks!
Hi everyone,
I am trying to italicize a cell (B7) based on if the letter S is anywhere in C7.
I have already tried the formula $C$7="*S*", but this doesn't work.
Does anyone know how to do this?
Thanks!
Try this:
Please Login or Register to view this content.
<--- Please click the star to say thank you
no need to put the entire IF condition:
=isnumber(find("s",$c$7))
would do it...
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
Yes that's much neater, however it won't work for a capital "S". If that's an issue then...
=ISNUMBER(FIND("s",LOWER($C$7))
if you want the search not to be case sensitive, use SEARCH()
=isnumber(search("s",$c$7))
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thanks everyone! All of your formulas worked!
if you want the search not to be case sensitive, use SEARCH()
=isnumber(search("s",$c$7))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks