Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Is there any way I can perform calculation on the basis of cell formatting
such as get the sum of highlighted cells |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#6
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Highlighted cell | New Users to Excel | |||
Can't see highlighted selections | Setting up and Configuration of Excel | |||
Highlighted | New Users to Excel | |||
Highlighted row number | New Users to Excel | |||
Spreadsheet Highlighted | Setting up and Configuration of Excel |