CF formula for different words, same string

**jokris** · 05-06-2016, 03:38 AM

How do I achieve this with conditional formatting formula to a whole column?

If a cell in range E:G in any row contains the string "tea" (like "steam"), then fill the cell in the same row but column A with red color.

But if a call in same range instead contains string "teaspoon" (which also contains string "tea") I want to fill column B same row cell red instead.

Tried with OR(ISNUMBER(SEARCH with ISNUMBER(NOT(SEARCH but couldn't come up with a solution.

In attached file I just used ordinary fill color tool to show what I want to achieve.

**zbor** · 05-06-2016, 03:48 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

**jokris** · 05-06-2016, 03:52 AM

Changed it now to a better thread title

In this file I used CF but can't get "tea" string to work ("teaspoon" string works though)

**jokris** · 05-06-2016, 06:20 AM

Originally Posted by zbor

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Is this thread possible to move to "Formula and functions"?

**zbor** · 05-06-2016, 06:23 AM

Moved although won't effect final result.
Hope you'll get it soon.

**José Augusto** · 05-06-2016, 07:08 AM

Hi
Use these formulas to get the answers
Has sub string "tea"

Formula:

Please Login or Register  to view this content.

A1 has value "tea"
Has sub string "tea" but not the string "teaspoon"

Formula:

Please Login or Register  to view this content.

CF formula for different words, same string

LinkBack

Thread Tools

Rate This Thread

Display

CF formula for different words, same string

Re: Macro formula

Re: Macro formula for different words, same string

Re: Macro formula

Re: CF formula for different words, same string

Re: CF formula for different words, same string

Thread Information

Users Browsing this Thread

Similar Threads

Problem with recording a macro with long formula - works in Excel but not in macro

VBA Macro: Plugging an Array-Formula into a Cell and Dragging Formula Down Columns

macro trigger based on the result of a formula (whenever the formula for calculating)

Macro: Applying formula to multiple cells in excel (formula editing)

Formula/macro - Apply certain formula as per duplicate cells in column L

[SOLVED] Formula expected end of statement error, typing formula into cell as part of VBA macro

Bookmarks

Bookmarks

Posting Permissions