Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Conditional Format question
How can I create a format for the cells which contains a certain substring?
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 --- |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional format question.. | Excel Worksheet Functions | |||
Conditional Format Question | Excel Discussion (Misc queries) | |||
Another Conditional Format Question | New Users to Excel | |||
question about conditional format | Excel Discussion (Misc queries) | |||
Conditional Format Question | Excel Worksheet Functions |