Sum of Highlighted values
 

Is there any way I can perform calculation on the basis of cell formatting
such as get the sum of highlighted cells

Sum of Highlighted values
 

http://xldynamic.com/source/xld.ColourCounter.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Khusro" wrote in message
...
Is there any way I can perform calculation on the basis of cell formatting
such as get the sum of highlighted cells

Sum of Highlighted values
 

How are the cells highlighted, is it conditional formatting or a fill colour?
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Khusro" wrote:

Is there any way I can perform calculation on the basis of cell formatting
such as get the sum of highlighted cells

Sum of Highlighted values
 

Sub sumselection()'non-contiguous assign to button or shape
MsgBox Application.Sum(Selection)
End Sub

'below ONLY if a contiguous selection.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
MsgBox Application.Sum(Selection)
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Khusro" wrote in message
...
Is there any way I can perform calculation on the basis of cell formatting
such as get the sum of highlighted cells

Sum of Highlighted values
 

I probably misread the post but this may still be useful

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
Sub sumselection()'non-contiguous assign to button or shape
MsgBox Application.Sum(Selection)
End Sub

'below ONLY if a contiguous selection.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
MsgBox Application.Sum(Selection)
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Khusro" wrote in message
...
Is there any way I can perform calculation on the basis of cell
formatting
such as get the sum of highlighted cells

Sum of Highlighted values
 

On Sun, 24 Jan 2010 12:41:15 -0600, "Don Guillett"
wrote:

I probably misread the post but this may still be useful


He does know about the stats given on the status bar at the bottom of
the currently selected widow, right?