Conditional formatting - change color of data label in pie chart

[Aviles]

Hello,
I'm trying to change the color of data labels in a pie chart according to the percentage value. e.g. If =< 5%, then Black, If >5%, then White
After some research I tried entering a custom format code in the 'Number' category under 'Format Data Labels', but this didn't work: [Black][=<0.05]0%;[White][>0.05]0%
Are there any other options to accomplish what I am trying to achieve? I'm open to VBA also if it makes it easier.
Thanks.

 

[Aviles]

I found this code on another thread which I think is what I'm looking for.

Could some one help me to apply this code to my pie chart please? My chart name is "Chart 26" and the data labels are "Series 3 Data Labels"

I tried to amend the code but didn't have any luck.

Thanks.

[/SIZE]Sub LabelFontColor()

    Dim ser As Series
    Dim ser_vals As Variant
    Dim num As Byte
    
    '[SIZE=3][/SIZE][SIZE=2]change[/SIZE] this line as necessary
    Set ser = ActiveSheet.ChartObjects(1).Chart.SeriesCollection(1)
    ser_vals = ser.Values
    
    For num = LBound(ser_vals) To UBound(ser_vals)
        With ser.Points(num).DataLabel.Format.TextFrame2.TextRange.Font.Fill.ForeColor
            If ser_vals(num) >= 0.3 Then
                .ObjectThemeColor = msoThemeColorAccent3
            Else
                .ObjectThemeColor = msoThemeColorAccent2
            End If
        End With
    Next num
    
End Sub

[SIZE=2]