Numbers to be black

[sksanjeev786]

Hi Team,

I have kept the condition on symbol and it appeared on number also but I need the number to be black is any there anyway.

Hot Bevearge_FS.xlsx
	G	H	I	J	K	L	M
63	36	41	39 (-1▼)	24	18	28	17
64	35	40 (+7▲)	37	21	16	25	14
65	41	50 (+9▲)	40	26	22	30	18
66	39	42	42	28	23	30	20
67	36	40 (+5▲)	30	25	19	23	16
68	31	35	32	16	12	22	13
69	38	44 (+6▲)	40	26	24	28	20
70	41	46 (+6▲)	34	26	22	25	19
71	35	42 (+6▲)	26	23	19	22	17
72	42	46 (+8▲)	36	31 (+5▲)	25	30	22
12 (2)

Cell Formulas
Range	Formula
G63:M72	G63	=IFERROR(VALUE(G85&" "&IF(IFERROR(ROUND(IF(FIND(G$39,AC41),G85-AC85),0),"")="","","("&IFERROR(ROUND(IF(FIND(G$39,AC41),G85-AC85),0),"")&IFERROR(IF(FIND($D$64,AC41),$C$64),"")&")")&IF(IFERROR(ROUND(IF(FIND(AC$39,G41),G85-AC85),0),"")="","","(+"&IFERROR(ROUND(IF(FIND(AC$39,G41),G85-AC85),0),"")&IFERROR(IF(FIND($D$63,G41),$C$63),"")&")")),G85&" "&IF(IFERROR(ROUND(IF(FIND(G$39,AC41),G85-AC85),0),"")="","","("&IFERROR(ROUND(IF(FIND(G$39,AC41),G85-AC85),0),"")&IFERROR(IF(FIND($D$64,AC41),$C$64),"")&")")&IF(IFERROR(ROUND(IF(FIND(AC$39,G41),G85-AC85),0),"")="","","(+"&IFERROR(ROUND(IF(FIND(AC$39,G41),G85-AC85),0),"")&IFERROR(IF(FIND($D$63,G41),$C$63),"")&")"))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G63:W79	Expression	=FIND($C$64,G63)	text	NO
G63:W79	Expression	=FIND($C$63,G63)	text	NO

Thanks.
Regards,
Sanjeev

 

[Fluff]

You're welcome & thanks for the feedback.