Conditional Format question
How can I create a format for the cells which contains a certain substring?
|
Conditional Format question
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 --- |
Conditional Format question
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? |
Conditional Format question
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? |
All times are GMT +1. The time now is 12:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com