Hello. Excel 2003.
I would like to apply conditional formatting to a column where the cell's text contains a word.
Is it possible to do this with a wildcard character ="*some*" or do I need to use a function FIND or SEARCH
as part of a formula?
Thanks, Andy.
Conditional formatting on embedded word
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Conditional formatting on embedded word
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
- 5StarLounger
- Posts: 689
- Joined: 27 Jan 2010, 16:45
- Location: Ottawa, Ontario, Canada
Re: Conditional formatting on embedded word
Assuming the the column of interest is "A".agibsonsw wrote:Hello. Excel 2003.
I would like to apply conditional formatting to a column where the cell's text contains a word.
Is it possible to do this with a wildcard character ="*some*" or do I need to use a function FIND or SEARCH
as part of a formula?
Thanks, Andy.
- Select the entire column
- Pull down 'Format > Conditional Formatting'
- Select 'Formula Is'
- Enter the following formula
Or simply:
=FIND("some",A1)
Regards
Don
Don
-
- 5StarLounger
- Posts: 818
- Joined: 24 Jan 2010, 15:56
Re: Conditional formatting on embedded word
If you don't want case-sensitivity, then use SEARCH rather than FIND, or use COUNTIF with wildcards.
Regards,
Rory
Rory
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Re: Conditional formatting on embedded word
Hello. Thanks both.
So wildcard characters only apply to COUNTIF, SUMIF, etc., and auto-filtering within Excel? Andy.
So wildcard characters only apply to COUNTIF, SUMIF, etc., and auto-filtering within Excel? Andy.
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
- Administrator
- Posts: 78788
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Conditional formatting on embedded word
Wildcards definitely do NOT work in a formula such as ="*some*"; the = operator looks for an exact match.
Best wishes,
Hans
Hans