| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a fuction that counts number of highlighted cells Excell
I want to total the number of highlighted or specific fill color cells in a
range. The data in the cell in not my concer just the highlight or fill. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there a fuction that counts number of highlighted cells Excell
Call with below call. Note: The code below will not automatically update
when color get changed. Color changes do not cause a recalculation of the spreadsheet. =FilledCells(B7:D10) Function FilledCells(Target As Range) Count = 0 For Each Cell In Target If Cell.Interior.ColorIndex < xlNone Then Count = Count + 1 End If Next Cell FilledCells = Count End Function"bstrack" wrote: I want to total the number of highlighted or specific fill color cells in a range. The data in the cell in not my concer just the highlight or fill. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there a fuction that counts number of highlighted cells Exc
Hi Joel, you didn't include the cell colored by conditional formatting. they
have to have the FormatCondidtions(1) thing thrown in like: If Cell.FormatConditions(1).Interior.ColorIndex < xlNone "Joel" wrote: Call with below call. Note: The code below will not automatically update when color get changed. Color changes do not cause a recalculation of the spreadsheet. =FilledCells(B7:D10) Function FilledCells(Target As Range) Count = 0 For Each Cell In Target If Cell.Interior.ColorIndex < xlNone Then Count = Count + 1 End If Next Cell FilledCells = Count End Function"bstrack" wrote: I want to total the number of highlighted or specific fill color cells in a range. The data in the cell in not my concer just the highlight or fill. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a function that counts number of cells in a series | Excel Worksheet Functions | |||
| how to turn off highlighted cells when openning an excell file | Excel Discussion (Misc queries) | |||
| Count number of cells that are highlighted | Excel Programming | |||
| a function that counts the number of cells with information | Excel Worksheet Functions | |||
| Is there a way to count the number of highlighted cells in a col? | Excel Discussion (Misc queries) | |||
Hybrid Mode
