Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
Option Explicit Function CountByColor(CellColor As Range, SumRange As Range) Dim myCell As Range Dim iCol As Integer Dim myTotal iCol = CellColor.Interior.ColorIndex For Each myCell In SumRange If myCell.Interior.ColorIndex = iCol Then myTotal = myTotal + 1 End If Next myCell CountByColor = myTotal End Function
|Excel VBA - UserForm control click||12||35|
|Execl - Adding user comments based on cell contents||5||32|
|VLOOKUP Function MS Excel 2010||2||20|
|How to check with VBA if an excel formula has multiple terms in it?||2||18|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
15 Experts available now in Live!