Condition color to bubble

[sksanjeev786]

Hi Team,

I need help in change the color as per column K to M in Column D to F with bubble color format is in A2 to A4 and where ever no color I need orange bubble color

FS Grouping.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
2	●
3	●			A	B	C	X				A	B	C	X
4	●
5			SEEN AD (NET)	19 ●	15	22 ●	16			SEEN AD (NET)	19 X	15	22 X	16
6			Correctly Branded (net)	3.87 ●	3.67	4.09 ●	3.68			Correctly Branded (net)	3.87 X	3.67	4.09 X	3.68
7			The Ad Is Likeable	3.15	3.14	3.17	3.19			The Ad Is Likeable	3.15	3.14	3.17	3.19
8			The Ad Told Me Something New	2.83 ●	2.84	2.83	2.92 A			The Ad Told Me Something New	2.83	2.84	2.83	2.92 A
9			Top 2 Box (net)	2.75 ●	2.69 ●	2.82 ●	2.95 ABC			Top 2 Box (net)	2.75	2.69	2.82	2.95 ABC
10			Top 2 Box (net)	2.91	2.99	2.84				Top 2 Box (net)	2.91	2.99	2.84
11
12			The Ad Is Likeable	3.27 ●	3.2	3.35	3.25			The Ad Is Likeable	3.27 X	3.20	3.35	3.25
13			The Ad Told Me Something New	3 ●	2.97 ●	3.04 ●	3.22 ABC			The Ad Told Me Something New	3.00	2.97	3.04	3.22 ABC
14			It Made Me Want To Visit The Dealership Or Take A Test Drive	2.93 ●	2.9 ●	2.97 ●	3.16 ABC			It Made Me Want To Visit The Dealership Or Take A Test Drive	2.93	2.90	2.97	3.16 ABC
15			The Ad Made Me Want To Find Out More About The Vehicle (search Online/read Articles)	3.32	3.26	3.37				The Ad Made Me Want To Find Out More About The Vehicle (search Online/read Articles)	3.32	3.26	3.37
grouping

Cell Formulas
Range	Formula
D5:G10,D12:G15	D5	=SUBSTITUTE(K5,"X","")&" "&IFERROR(IF(FIND(D$3,$N5),$A$2,""),"")&IFERROR(IF(FIND($G$3,K5),$A$3,""),"")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
K5:M27	Expression	=FIND($N$3,K5)	text	NO
K5:M27	Expression	=FIND(K$3,$N5)	text	NO
H5:I26	Expression	=FIND("M",#REF!)	text	NO
H5:I26	Expression	=FIND("N",#REF!)	text	NO

Cells with Data Validation
Cell	Allow	Criteria
A5:A14	List	=$A$1208:$A$1244

Thanks in advance
Sanjeev

 

[sksanjeev786]

conditional formatting menu

Hi Tinajoy,

I have applied conditional formatting but getting both symbols and numbers are in the same color but I need the number to be black after applying condition formatting.

Thanks.
Sanjeev.

 

[tinajoy]

Have you tried highlighting the cell and giving the conditions one after another on the same cell? Please send an image to give a better idea.

 

[sksanjeev786]

Have you tried highlighting the cell and giving the conditions one after another on the same cell? Please send an image to give a better idea.

Hi Tinajoy,

below is the table with my data as I need data in black and symbol in color

FS Grouping.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1
2	●
3	●			A	B	C	X				A	B	C	X
4	●
5			SEEN AD (NET)	19 ●	15	22 ●	16			SEEN AD (NET)	19 X	15	22 X	16
6			Correctly Branded (net)	3.87 ●	3.67	4.09 ●	3.68			Correctly Branded (net)	3.87 X	3.67	4.09 X	3.68
7			The Ad Is Likeable	3.15	3.14	3.17	3.19			The Ad Is Likeable	3.15	3.14	3.17	3.19
grouping

Cell Formulas
Range	Formula
D5:G7	D5	=SUBSTITUTE(K5,"X","")&" "&IFERROR(IF(FIND(D$3,$N5),$A$2,""),"")&IFERROR(IF(FIND($G$3,K5),$A$3,""),"")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D5:F10	Expression	=FIND($N$3,K5)	text	NO
D5:F10	Expression	=FIND(D$3,$N5)	text	NO
K5:M27	Expression	=FIND($N$3,K5)	text	NO
K5:M27	Expression	=FIND(K$3,$N5)	text	NO
H5:I26	Expression	=FIND("M",#REF!)	text	NO
H5:I26	Expression	=FIND("N",#REF!)	text	NO

Cells with Data Validation
Cell	Allow	Criteria
A5:A7	List	=$A$1208:$A$1244

Thanks in advance.
Regards,
Sanjeev

 

[Fluff]

As you have already been told, conditional formatting affects the entire cell, so you cannot change the colour of the symbol only.

 

[sksanjeev786]

As you have already been told, conditional formatting affects the entire cell, so you cannot change the colour of the symbol only.

Sure Fluff.

This was an old query I have posted and I got a response due I just give the info.

Sorry and thanks for checking Fluff

Regards,
Sanjeev