iconset in vsto does not work (excel conditional formatting)

Jonathan Brotto 1,076 Reputation points
2022-01-20T19:09:27.95+00:00

I could add an icon conditional formatting but get the circles instead of the arrow which I try to change with the iconset line but nothing happens

VBA portion id .IconSet = ActiveWorkbook.IconSets(xl3Triangles)

        With customerYearRng
            .FormatConditions.AddIconSetCondition()
            .FormatConditions(1).IconSet = Excel.XlIconSet.xl3Arrows


            With .FormatConditions(1).IconCriteria(2)
                .Type = Excel.XlConditionValueTypes.xlConditionValueNumber
                .Value = 0
                .Operator = 7
            End With
            With .FormatConditions(1).IconCriteria(3)
                .Type = Excel.XlConditionValueTypes.xlConditionValueNumber
                .Value = 0
                .Operator = 5
            End With
        End With
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,569 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,488 questions
0 comments No comments
{count} votes