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?