هذا هو الكود الرجاء يعض التعديلات علية لياخذ من صف الدرجات اى لا يتقديد ب 15 او 40 درجة فى الدرجة ةالترم2
Sub ÖÇÝÉ_ÍÐÝ2()
On Error Resume Next
Dim XX As Shape
Set XX = ActiveSheet.Shapes("ÇáÏÇÆÑÉ")
With XX.TextFrame.Characters
If .Text = "ÇÖÇÝÉ ÇáÏæÇÆÑ" Then
Circles2
.Text = "ÍÐÝ ÇáÏæÇÆÑ"
Else
RemoveCircles1
.Text = "ÇÖÇÝÉ ÇáÏæÇÆÑ"
End If
End With
On Error GoTo 0
End Sub
Sub Circles2()
Dim C As Range
Dim MyRng As Range, V As Shape
Dim X As Integer, G As Integer, R As Integer, D As Integer
'================================================
G = 2 ' ÚãæÏ ÑÞã ÇáÌáæÓ
R = 7 ' ÕÝ ÇáÏÑÌÇÊ
'================================================
X = Activewindow.Zoom
Application.ScreenUpdating = False
Activewindow.Zoom = 100
For Each C In Range("D5:AE154")
'If Cells(C.Row, G) = 0 Then GoTo 1
If Cells(4, C.Column).Value = "ÊÑã2" And C.Value <> "" And (C.Value < 15 Or C.Value = "Û" Or C.Value = "ÕÝÑ") Then
Set V = ActiveSheet.Shapes.AddShape(msoShapeRoundedRectangle, C.Left + 3, C.Top + 3, C.Width - 6, C.Height - 6)
V.Fill.Visible = msoFalse
V.Line.ForeColor.SchemeColor = 12
V.Line.Weight = 1.75
TT = TT + 1
End If
If Cells(4, C.Column).Value = "ÇáÏÑÌÉ" And C.Value <> "" And (C.Value < 40 Or C.Value = "Û" Or C.Value = "ÕÝÑ") Then
Set V = ActiveSheet.Shapes.AddShape(msoShapeOval, C.Left + 3, C.Top + 3, C.Width - 6, C.Height - 6)
V.Fill.Visible = msoFalse
V.Line.ForeColor.SchemeColor = 10
V.Line.Weight = 1.75
D = D + 1
End If
1 Next
Activewindow.Zoom = X
Application.ScreenUpdating = True
MsgBox "Êã ÅÖÇÝÉ " & TT & " ãÑÈÚ æ " & D & " ÏÇÆÑÉ ÈäÌÇÍ", vbMsgBoxRtlReading, "ÇáÍãÏááå"
End Sub