How can I create a format for the cells which contains a certain substring?

How can I create a format for the cells which contains a certain
substring?

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 FormatConditional formatting with this formula:
Select column A and enter formula in CF dialog:
=NOT(ISERROR(SEARCH("putasubstringhere",A1)))

Regards,
Stefi

€žst€� ezt Ã*rta:

How can I create a format for the cells which contains a certain substring?

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.


--
Thanks,
Shane Devenshire


"st" wrote:

How can I create a format for the cells which contains a certain substring?