VBA Support: Need to convert cell colour to arrow

[sksanjeev786]

Hi Team,

I need help on the below table i have input data from A1 to G15 and i need output that looks like J3 to P15

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
2	Brand Metrics	Control	Exposed	∆	Control	Exposed	∆
3	Unaided Brand Awareness	5%	8%	4%	7%	9%	2%			Unaided Brand Awareness	5	8	4	p	7	9	2
4	Aided Brand Awareness	78%	86%	8%	76%	80%	4%			Aided Brand Awareness	78	86	8	p	76	80	4	r
5	TV Ad Awareness	25%	40%	15%	37%	46%	9%			TV Ad Awareness	25	40	15	p	37	46	9	p
6	Message Association	19%	26%	7%	22%	22%	0%			Message Association	19	26	7	p	22	22	0
7	Brand Favorability	50%	67%	18%	55%	65%	10%			Brand Favorability	50	67	18	p	55	65	10	p
8	Consideration Intent	49%	62%	14%	56%	66%	9%			Consideration Intent	49	62	14	p	56	66	9	p
9	Brand Attributes									Brand Attributes
10	Turns plain water into fresh sparking water in seconds	67%	77%	10%	66%	72%	6%			Turns plain water into fresh sparking water in seconds	67	77	10	p	66	72	6	p
11	Allows me freedom of choice with a variety of flavors	64%	76%	12%	64%	72%	8%			Allows me freedom of choice with a variety of flavors	64	76	12	p	64	72	8	p
12	Is more environmentally friendly than single-use plastic bottles	65%	76%	11%	62%	67%	5%			Is more environmentally friendly than single-use plastic bottles	65	76	11	p	62	67	5	r
13	Allows me to make my own healthier sparking drinks the way I like	64%	74%	10%	62%	68%	6%			Allows me to make my own healthier sparking drinks the way I like	64	74	10	p	62	68	6	p
14	Empowers me to make better choices	47%	67%	20%	53%	65%	12%			Empowers me to make better choices	47	67	20	p	53	65	12	p
15	n	368	413		431	392				Sample Size (c/e)	(368)	(413)			(431)	(392)
Sheet1

 

[sksanjeev786]

Hi Team,

I need help on the below table i have input data from A1 to G15 and i need output that looks like J3 to P15

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
2	Brand Metrics	Control	Exposed	∆	Control	Exposed	∆
3	Unaided Brand Awareness	5%	8%	4%	7%	9%	2%			Unaided Brand Awareness	5	8	4	p	7	9	2
4	Aided Brand Awareness	78%	86%	8%	76%	80%	4%			Aided Brand Awareness	78	86	8	p	76	80	4	r
5	TV Ad Awareness	25%	40%	15%	37%	46%	9%			TV Ad Awareness	25	40	15	p	37	46	9	p
6	Message Association	19%	26%	7%	22%	22%	0%			Message Association	19	26	7	p	22	22	0
7	Brand Favorability	50%	67%	18%	55%	65%	10%			Brand Favorability	50	67	18	p	55	65	10	p
8	Consideration Intent	49%	62%	14%	56%	66%	9%			Consideration Intent	49	62	14	p	56	66	9	p
9	Brand Attributes									Brand Attributes
10	Turns plain water into fresh sparking water in seconds	67%	77%	10%	66%	72%	6%			Turns plain water into fresh sparking water in seconds	67	77	10	p	66	72	6	p
11	Allows me freedom of choice with a variety of flavors	64%	76%	12%	64%	72%	8%			Allows me freedom of choice with a variety of flavors	64	76	12	p	64	72	8	p
12	Is more environmentally friendly than single-use plastic bottles	65%	76%	11%	62%	67%	5%			Is more environmentally friendly than single-use plastic bottles	65	76	11	p	62	67	5	r
13	Allows me to make my own healthier sparking drinks the way I like	64%	74%	10%	62%	68%	6%			Allows me to make my own healthier sparking drinks the way I like	64	74	10	p	62	68	6	p
14	Empowers me to make better choices	47%	67%	20%	53%	65%	12%			Empowers me to make better choices	47	67	20	p	53	65	12	p
15	n	368	413		431	392				Sample Size (c/e)	(368)	(413)			(431)	(392)
Sheet1

View attachment 75156

HI Team

Can anyone help me on above thing

Regards
Sanjeev