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]

Conditional formatting applies to the entire cell, so you cannot just change the colour of the symbol on it's own.

 

[sksanjeev786]

Conditional formatting applies to the entire cell, so you cannot just change the colour of the symbol on it's own.

Hi Fluff,

I have applied condition forming to the symbol also but still color change to font also.
Please see the screenshot

Let us know if we find out in another way
Regards,
Sanjeev

 

[Fluff]

As long as you have a formula in the cell, there is no way to change the colour of one part of the value.

 

[sksanjeev786]

As long as you have a formula in the cell, there is no way to change the colour of one part of the value.

Hi Fluff,

I can help with a few things like I have a macro for this but I am facing a challenge when I am pasting this data to the PPT table I am getting all in black but in excel it showing the color. can we get some idea on the below macro? also please see the image as attached

Sub changecolor()

Dim a As Integer
Dim b As Integer
Dim c As Integer
Dim d As Integer

For i = 4 To 20
For j = 4 To 20

Cells(i, j).Interior.ColorIndex = 0

a = InStr(Cells(i, j).Value, "+")
b = Len(Cells(i, j).Value)

If a > 2 Then
Worksheets("Sheet1").Cells(i, j).Characters(Start:=a - 1, Length:=b).Font.ColorIndex = 10
End If

c = InStr(Cells(i, j).Value, "-")
d = Len(Cells(i, j).Value)

If c > 2 Then
Worksheets("Sheet1").Cells(i, j).Characters(Start:=c - 1, Length:=d).Font.ColorIndex = 3
End If

Next j
Next i

MsgBox ("Task Done")
Cells(4, 4).Select

End Sub

 

[Fluff]

If those cells contain a formula as in your op, then you cannot change the colour of just part of the cell.
As regards PPT, that is a totally different question & will need a new thread.

 

[sksanjeev786]

If those cells contain a formula as in your op, then you cannot change the colour of just part of the cell.
As regards PPT, that is a totally different question & will need a new thread.

Sure Fluff

Thank you.

Will create a new thread for this.

Regards,
Sanjeev

 

[sksanjeev786]

Sure Fluff

Thank you.

Will create a new thread for this.

Regards,
Sanjeev

Hi Fluff,

To make it simple I have removed all formulas in the cells and now only kept condition formating but still, I am getting color in data. now there is any way to keep data in black color I have

Book1
	A	B	C
1	▲
2	▼
3		30 (+4▲)	30 (+4)
4		31 (+4)	31 (+4)
5		32 (-4▼)	32 (+4▼)
6		33 ▼	33 (+4)
7		34 ▲	34 (+4)
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B3:C7	Expression	=FIND($A$2,B3)	text	NO
B3:C7	Expression	=FIND($A$1,B3)	text	NO

Thanks in advance.
Sanjeev

 

[Fluff]

Not with conditional formatting, you will need to use your macro.

 

[sksanjeev786]

sure thanks Fluff for your time and understanding our point.

Not with conditional formatting, you will need to use your macro.