Conditional Formatting Based on Text with Wildcard

S

sunday_storyteller

Board Regular
Joined
Jun 22, 2007
Messages
51
Can I choose to highlight rows based on a cell in that row containing specific text.

For example, I have data in 4 columns. Columns A, B, C, and D.
In column B, there are lists of customers.
I would like to highlight any rows where the customer has the text value "TDMN" somewhere in cell B for that row. It might say, for example, "CUSTOMER TDMN2 CUSTOMERADDRESS", and I would like that row highlighted.
I had been doing this by hand, but there are hundreds of lines, potentially, and it would be much easier to conditionally highlight anything that contains *TDMN*. Is that possible? I tried several variations of that formula in the highlighting and couldn't come up with anything that worked.

Thanks!
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Sort by date Sort by votes
Yep, highlight your range, click format - conditional formatting

select "Formula Is"

Enter the formula
Code: 
=ISNUMBER(SEARCH("TDMN",$B1))

NOTE, at the time you enter the formula, B1 should reflect the ROW in the NAME box (to the left of formula bar)

Click Format - Setup your format as desired
click ok
click ok
 
Upvote 0
You must log in or register to reply here.

Similar threads

I
  • Question
Conditional formatting with multiple conditions
Replies
3
Views
159
Peter_SSs
Peter_SSs
R
  • Solved
Using conditional formatting to highlight the row of a cell containing specific text.
Replies
4
Views
237
etaf
etaf
V
  • Solved
Conditional Formatting Formula
Replies
2
Views
492
awoohaw
awoohaw
Y
  • Solved
Conditional formatting formula
Replies
7
Views
244
Peter_SSs
Peter_SSs
W
  • Solved
Copying Conditional Formatting with relative values
Replies
9
Views
496
weeksy
W

Forum statistics

Threads
1,214,657
Messages
6,120,773
Members
448,991
Latest member
Hanakoro

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top