Excel - How to Use Conditional Formatting With IF Statement - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I need a formula in conditional formatting to shade cell O4 blue if cell F4 contains part of "District Active Support Member"
Solved by G. U. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 19/09/2018 - 11:35
Hello
Excelchat Expert 19/09/2018 - 11:35
Welcome to Excelchat, I see that your question is about conditional formatting.
Excelchat Expert 19/09/2018 - 11:35
I can help you with that problem.
User 19/09/2018 - 11:36
Hi I should be able to as well but cant nail this one
Excelchat Expert 19/09/2018 - 11:36
Before we get started, this is a reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows.
Excelchat Expert 19/09/2018 - 11:36
Ok.
Excelchat Expert 19/09/2018 - 11:36
Let me ask you a couple of quick questions to make sure I fully understand your problem.
User 19/09/2018 - 11:37
ok
User 19/09/2018 - 11:37
ok
Excelchat Expert 19/09/2018 - 11:37
F4 should contain "District Active Support Member" then O4 to turn blue?
Excelchat Expert 19/09/2018 - 11:37
is that correct?
User 19/09/2018 - 11:38
Only part of the text string eg Active Support
Excelchat Expert 19/09/2018 - 11:38
so what all possibilities are there?
Excelchat Expert 19/09/2018 - 11:39
1. District Active
Excelchat Expert 19/09/2018 - 11:39
2. Active Support.
Excelchat Expert 19/09/2018 - 11:39
3. Support Member
Excelchat Expert 19/09/2018 - 11:39
should we consider single words too?
User 19/09/2018 - 11:40
Just that so that I can isolate other roles in fifferent cells
User 19/09/2018 - 11:41
It will always be two words
Excelchat Expert 19/09/2018 - 11:41
so 3 possibilities only then?
User 19/09/2018 - 11:41
No one possibility only
User 19/09/2018 - 11:42
But not the whole string
Excelchat Expert 19/09/2018 - 11:42
As you mentioned - Only part of the text string eg Active Support
Excelchat Expert 19/09/2018 - 11:43
So only possibility will be Active Support?
User 19/09/2018 - 11:43
yes
Excelchat Expert 19/09/2018 - 11:43
Ok.
Excelchat Expert 19/09/2018 - 11:43
Understood.
Excelchat Expert 19/09/2018 - 11:44
Should I guide you on how to do it or should I do it on a excel file and send it to you?
User 19/09/2018 - 11:44
Do it on an excel file please
Excelchat Expert 19/09/2018 - 11:44
Ok
Excelchat Expert 19/09/2018 - 11:45
This should take me few minutes to solve. If prompted for extension of session, please do so.
User 19/09/2018 - 11:45
Thank you
Excelchat Expert 19/09/2018 - 11:49
Please find attach the required file.
[Uploaded an Excel file]
Excelchat Expert 19/09/2018 - 11:49
Kindly confirm this is what was required.
Excelchat Expert 19/09/2018 - 11:52
Are you still there?
Excelchat Expert 19/09/2018 - 11:52
Let me explain how this conditional formatting works.
Excelchat Expert 19/09/2018 - 11:53
I have selected O4 - conditional Formatting under Home tab
Excelchat Expert 19/09/2018 - 11:53
New Rule - Use of formula to determine which cell to format.
Excelchat Expert 19/09/2018 - 11:54
Then using this formula in the conditional formatting.
Excelchat Expert 19/09/2018 - 11:54
=SEARCH("Active Support",$F$4)
Excelchat Expert 19/09/2018 - 11:54
then selecting Format and select the Fill option and chose blue color.
Excelchat Expert 19/09/2018 - 11:55
Click Ok. Click Apply.

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc