excel 2003 - formula?

[mak]

hi
my ranking formula is this one (it is yours i think, and I don't think that needs notification)

=IF(F5="";"";(RANK(F5;$F$5:$F$55;1)+COUNTIF($F$5:F5;F5)-1))

regarding level profit column now that I check it again I think you are right...
I was trying to test it with another bot placing bets and the column was like the profit loss in BA...

Can you tell me how to "call" the Green macro if cell aq1="Y" ?

[osknows]

the ranking formula will work in all versions of Excel.


Code to just trigger greenup is the following in the sheet object

Code: Select all

Private Sub Worksheet_Change(ByVal Target As Range)

    If Target.Columns.Count <> 16 Then Exit Sub
    Application.EnableEvents = False
    With Target.Parent
        If UCase(.Range("AQ1").Value) = "Y" Then
            GreenSheet1_Click
        End If
    End With
    Application.EnableEvents = True
           
End Sub

[mak]

Thanks!
You got PM