Need Green and Red color to arrow but data are in formula

[sksanjeev786]

Hi Team

My data are in the formula so I need red and green colors only on the arrow not on data... and my all data are in column N

FS_Lex(1-1000) and Beast.xlsx
	N
49	100%
50	60%
51	55% ▲
52	42% ▲
53	35%
54	39% ▲
55	50%
56	58% ▲
57	28%
58	35% ▼
59	36%
60	36%
61	39%
62	30%
63	31%
64	22%
65	33%
66	27%
67	18%
68	28%
Banner_FS_Stat Test

Cell Formulas
Range	Formula
N49:N68	N49	=H49*100&"%"&" "&IFERROR(IF(FIND($K$9,L49),N$1),"")&IFERROR(IF(FIND($L$9,K49),N$2),"")

 

[MARK858]

Can't you just use conditional formatting icons?

 

[Trevor G]

How are you adding the arrows? Are they symbols?

As Mark has indicated CF may help.

 

[sksanjeev786]

Can't you just use conditional formatting icons?

View attachment 119156

View attachment 119157

Hi ,

Thanks for checking on this

I need color on arrow

 

[sksanjeev786]

How are you adding the arrows? Are they symbols?

As Mark has indicated CF may help.

Hi

This are the text arrow with Airel font (unicode 9660 and 9650) up and downarrow..

so I need color only on arrow and my data are in formula.

Regards
Sanjeev

 

[Fluff]

You cannot change the format of part of a cell when it contains a formula.

 

[sksanjeev786]

You cannot change the format of part of a cell when it contains a formula.

Hi Fluff

Thanks for checking on this

so if i copy and entire data in a separate column (M column) without formula then can we get the color for arrow

 

[Fluff]

Yes, but you would need VBA.

 

[sksanjeev786]

Yes, but you would need VBA.

Yes! Fluff

 

[MARK858]

Looking again at the original post I don't think conditional formatting would work as I can't see a pattern in the placing of the "arrows" in the XL2BB posted, they look random to me.

It might be an option in another cell if there is data there showing the 2 numbers that are being compared for sksanjeev786 to make the decision where to place the arrows, but sksanjeev786 has only shown the one column and so I can't tell what else exists on the sheet.