Need help in Formatting in Excel

[sksanjeev786]

Hi Team,

Need your support in Formatting in excel with symbols .

I have already done with the formulas as per my requirements and now I need the same format attached in the Screenshot.

In excel due to multiple font, I am getting other different formats (Excel and Screenshot have the same data)
Can anyone help me this

FS1.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Ç
2	È		A	B	C	X		A	B	C	X			A	B		For "+" symbole
3	Ì
4
5
6		It makes me think that the Capital One Venture X card is a premium product	36Ì	30				36	30					36	30		33
7		It makes me think that Capital One offers the types of rewards I want	40 BÇ	27		29		40 BX	27		29			40	27		NA
8		I like the people in it	36 ÇÌ	25		27		36 X	25		27			36	25		29
9		It makes me think that choosing Capital One is a smart choice	35 BÇ	17È		28 B		35 BX	17		28 B			35	17		NA
10		It makes me think that Capital One is a brand for someone like me	34 B	19È		29 B		34 B	19		29 B			34	19		NA
11		It makes me think that Capital One is better than other brands of credit cards	30 BÇÌ	18		22		30 BX	18		22			30	18		21
12		It showed things I could relate to	30	23		28		30	23		28			30	23		32
13		It makes me think that Capital One is a brand that is leading the way	29Ì	24		26		29	24		26			29	24		27
14		It's my kind of ad	25Ì	23		23		25	23		23			25	23		24
Test (2)

Cell Formulas
Range	Formula
C6:D14	C6	=SUBSTITUTE(H6,"X","")&""&IFERROR(IF(FIND(C$2,$K6),$A$2,""),"")&IFERROR(IF(FIND($F$2,H6),$A$1,""),"")&IF(N6>$Q6,$A$3,"")
E6:E14	E6	=SUBSTITUTE(J6,"X","")&""&IFERROR(IF(FIND(E$2,$K6),$A$2,""),"")&IFERROR(IF(FIND($F$2,J6),$A$1,""),"")
F6:F14	F6	=SUBSTITUTE(K6,"X","")&" "&IFERROR(IF(FIND(F$2,$K6),$A$2,""),"")&IFERROR(IF(FIND($F$2,K6),$A$1,""),"")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C6:D14	Expression	=FIND($A$2,C6)	text	NO
C6:D14	Expression	=FIND($A$1,C6)	text	NO
E6:E14	Expression	=FIND($A$2,E6)	text	NO
E6:E14	Expression	=FIND($A$1,E6)	text	NO

Regards,
Sanjeev

 

[6StringJazzer]

The result of a formula must be all one format. You cannot use different fonts, colors, etc., for different characters for the result of a formula.

What you want to do will require VBA. How did you create the data shown in the screenshot attachment?

 

[sksanjeev786]

The result of a formula must be all one format. You cannot use different fonts, colors, etc., for different characters for the result of a formula.

What you want to do will require VBA. How did you create the data shown in the screenshot attachment?

Sure! thank you for looking into it.

Yes I need VBA and I hope I will get the same format I have shown in the Screenshot as attached

 

[6StringJazzer]

Maybe you missed my question.

How did you create the data shown in the screenshot attachment? Tell us what formats you are using.

 

[sksanjeev786]

Maybe you missed my question.

How did you create the data shown in the screenshot attachment? Tell us what formats you are using.

Sorry about that

I just updated the date, color, Arrow, and "+" symbol manually in the PPT file.


Regards,
Sanjeev

 

[6StringJazzer]

Right. I'll be more specific. In your image, for the row that starts "I like the people in it", what font are you using for "36"? What font are you using for the up-arrow? What font are you using for the "+" sign?

 

[sksanjeev786]

Right. I'll be more specific. In your image, for the row that starts "I like the people in it", what font are you using for "36"? What font are you using for the up-arrow? What font are you using for the "+" sign?

Sure,

Below are the details

For 36 = Arial
Up/Down= Wingdings 3
+= Wingdings 2

Let me know if you need anything else.

 

[sksanjeev786]

He

Sure,

Below are the details

For 36 = Arial
Up/Down= Wingdings 3
+= Wingdings 2

Let me know if you need anything else.

Hello Sir,

Hope you had chance to see the above things

Could you me help me this?

Regards
Sanjeev

 

[sksanjeev786]

He

Hello Sir,

Hope you had chance to see the above things

Could you me help me this?

Regards
Sanjeev

Hi Sir,

Could you please let me know if this is possible or not

otherwise, I need to update everything manually.

Regards,
Sanjeev

 

[6StringJazzer]

It is possible to do this with VBA but more of a project than I am able to do for you on a free forum at this time.