Conditional format cells with specific text based off results from drop down box

[jbarrick007]

I have cell C3 with a drop down that says either "All" or "Role Specific"

Could someone help me with the conditional format rule so that if C3 = "Role Specific" then all cell which contain a bullet point character "•" the font turns red. If it makes a difference the • is the fourth character after three blank spaces.
I know how to set the format style to red, I just don't know the right formula.

Thank so much.

 

[Toadstool]

Hi JonathanBarrick,

Does this do what you want?

Book1
	C
3	All
4	No bullet
5	• bulleted
6	No bullet
7	• bulleted
8	No bullet
9	• bulleted
10	• bulleted
11	• bulleted
12	No bullet
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C4:C12	Expression	=AND($C$3="All",FIND("•",C4))	text	NO

Cells with Data Validation
Cell	Allow	Criteria
C3	List	All,Role Specific

 

[jbarrick007]

Hi JonathanBarrick,

Does this do what you want?

Book1
	C
3	All
4	No bullet
5	• bulleted
6	No bullet
7	• bulleted
8	No bullet
9	• bulleted
10	• bulleted
11	• bulleted
12	No bullet
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C4:C12	Expression	=AND($C$3="All",FIND("•",C4))	text	NO

Cells with Data Validation
Cell	Allow	Criteria
C3	List	All,Role Specific

Thank you so very much!