include Difference with Average Count and Sum?

[drewg]

when i right click on the task bar at the very bottom of the workbook, a customize menu appears that lets you toggle what is displayed.
I would like to see the difference between two adjacent cells displayed when that's all thats highlighted, but there is no Difference on the menu.
Can i get difference between two cells on the menu without too much heavy lifting?
thanks very much
drew

 

[Nalani]

For the Worksheet you are worknig on, try this in the Sheet Module

Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Cells.Count = 2 Then
        Application.StatusBar = "Difference = " & _
            WorksheetFunction.Max(Target) - WorksheetFunction.Min(Target)
    End If
    Application.Wait (Now + TimeValue("0:00:02"))  '///  2 second delay before StatusBar returns to normal
    Application.StatusBar = False  ' // You can delete this line and the one above if you want Status to remain
End Sub

If you need it to be a permanent Feature for all workbooks, then I do not know how. Maybe somebody else will know.

 

[drewg]

it works....thanks very much
is it possible to move it way to the right with the rest of the values?
drew