Conditional Format question

  • Thread starter Thread starter st
  • Start date Start date
How can I create a format for the cells which contains a certain
substring?
Click to expand...

Select col A (A1 active), then apply the CF using Formula Is:
=ISNUMBER(SEARCH("diesel fuel",A1))
Format to taste > ok out

Replace SEARCH with FIND if you need it to be a stricter, case sensitive
search
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000, Files:362, Subscribers:62
xdemechanik
---
 
Cells being in column A use Format>Conditional formatting with this formula:
Select column A and enter formula in CF dialog:
=NOT(ISERROR(SEARCH("putasubstringhere",A1)))

Regards,
Stefi

„st†ezt írta:
 
Hi,

1. Highlight the cells you want to format, say A1:A100
2. Choose Format, Conditional Formatting, and from the first drop down pick
Formula is
3. In the second box enter the formula:

=SEARCH("t",A1)

4. Click Format button, Patterns tab, pick a color and click OK twice.

"t" is your substring, just put anything you want between the quotes.
 
Back
Top