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

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

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

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

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

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?