Hello,

After searching, apparently it is not possible to have a MFC with Icon, the relative references.

It is not possible to copy the shape of the other cell.

I retrieve the following code:

Is it possible to modify the code for

Compare cell A1 with B1 and put the arrow in A1:
green, high, if the value is greater than a B1
Blue, horizontal, and if the value is equal to B1
red, low, and if the value is less than a B1

it is repeating the range A1: B744

Thank you for your help

Sub Flech()

Range("A1:B10").Select
Selection.FormatConditions.AddIconSetCondition
Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
With Selection.FormatConditions(1)
.ReverseOrder = False
.ShowIconOnly = False
.IconSet = ActiveWorkbook.IconSets(xl3Arrows)
End With
With Selection.FormatConditions(1).IconCriteria(2)
.Type = xlConditionValuePercent
.Value = 33
.Operator = 7
End With
With Selection.FormatConditions(1).IconCriteria(3)
.Type = xlConditionValuePercent
.Value = 67
.Operator = 7
End With
End Sub