Conditional formatting formula with 'contains' text...not exact text

[unclejemima]

Right now I'm using a formula in conditional formatting that reacts if a cell has the value of text "have". But I'd like the formula to function if the cell contains "have" as well as other text...example "have 3" would still trigger it. Right now this formula does not do that...

=D3="Have"

Is this possible with conditional formatting...or only for exact phrases?

[josephteh]

Try: =MATCH("*have*",D3,0)

[thomglea]

Please Login or Register  to view this content.

[unclejemima]

I tried the =ISNUMBER(SEARCH("have"),d3)) and get an error "too few arguments for this function"

formula =MATCH("*have*",d3,0) appears to do the trick! Thanks everyone!

[thomglea]

I tried the =ISNUMBER(SEARCH("have"),d3)) and get an error "too few arguments for this function"

formula =MATCH("*have*",d3,0) appears to do the trick! Thanks everyone!

Sorry, typo :/

Please Login or Register  to view this content.

[josephteh]

thomglea's formula can be shortened to =SEARCH("have",D3)).

[thomglea]

thomglea's formula can be shortened to =SEARCH("have",D3)).

Unfortunately, it cannot :/ if "have" does not exist, the formula results in #VALUE! error. The ISNUMBER will return TRUE or FALSE.

[josephteh]

Have you tried? CF does not require error flagging.

[thomglea]

Hope this image uploads, if not, I will try again.
-edit removed image

[thomglea]

Blah, nevermind. Conditional Formatting. Yeah, that will return the true or false I guess. Still do not like formulas that evaluate to errors tho /shrug