Conditional formatting with pictograms

[SaskiaHe]

Hello,

I'm using the code below to apply conditional formatting with pictograms to a range of cells.

Now I want to check a pictogram in a cell. Whether is has a green or a red arrow or something like that. How can I accomplish that?

Any help would be greatly apprecated.

Saskia

    Range("G8:K14").Select
    With Selection.FormatConditions(1).IconCriteria(2)
        .Type = xlConditionValuePercent
        .Value = 20
        .Operator = 7
    End With
    With Selection.FormatConditions(1).IconCriteria(3)
        .Type = xlConditionValuePercent
        .Value = 40
        .Operator = 7
    End With
    With Selection.FormatConditions(1).IconCriteria(4)
        .Type = xlConditionValuePercent
        .Value = 60
        .Operator = 7
    End With
    With Selection.FormatConditions(1).IconCriteria(5)
        .Type = xlConditionValuePercent
        .Value = 80
        .Operator = 7
    End With

 

[SaskiaHe]

My apologies, the code above is not correct. Below is the right one:

Range("G8:K14").Select
    Selection.FormatConditions.AddIconSetCondition
    Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
    With Selection.FormatConditions(1)
        .ReverseOrder = False
        .ShowIconOnly = False
        .IconSet = ActiveWorkbook.IconSets(xl5Arrows)
    End With
    With Selection.FormatConditions(1).IconCriteria(2)
        .Type = xlConditionValuePercent
        .Value = 20
        .Operator = 7
    End With
    With Selection.FormatConditions(1).IconCriteria(3)
        .Type = xlConditionValuePercent
        .Value = 40
        .Operator = 7
    End With
    With Selection.FormatConditions(1).IconCriteria(4)
        .Type = xlConditionValuePercent
        .Value = 60
        .Operator = 7
    End With
    With Selection.FormatConditions(1).IconCriteria(5)
        .Type = xlConditionValuePercent
        .Value = 80
        .Operator = 7
    End With

 

[SaskiaHe]

if nobody can answer this question, can anybody tell me how the values are divided into the 5 groups?
I understand it roughly, but don't seem to be able to reproduce exactly.

Thanks in advance.

 

[SaskiaHe]

Does nobody understand how conditional formatting with icons work?

I'm trying to classify data into 5 categories and to determine in VBA to which category a value in a cell belongs.
As nobody answers, this either seems to be a very stupid question or Excel makes it so difficult that nodbody understands ...

If anybody understands though, please, please help me.