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.