Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel count how many cells have fill color
I am not sure how that would really do what I need it to do. There are 22 different stats each having a different goal. Only the stats that are above goal turn bule from the conditional formating. Then I just need it to tell me how many are blue.- ElkySS
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel count how many cells have fill color
** I will get this right one of these days. I am working an an Excel workbook that uses quite a few Macros to move and manipulate data that in input on a raw data sheet. Once it gets everything moved where it needs to go it runs a short macro that does some conditional formating and hilights...- ElkySS
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Make Excel count how many cells have a fill color
**Sorry for the dbl post. I put this in the Office forum prior to noticing that there was a VBA one. I am working an an Excel workbook that uses quite a few Macros to move and manipulate data that in input on a raw data sheet. Once it gets everything moved where it needs to go it runs a short...- ElkySS
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
-
Excel count how many cells have fill color
I am working an an Excel workbook that uses quite a few Macros to move and manipulate data that in input on a raw data sheet. Once it gets everything moved where it needs to go it runs a short macro that does some conditional formating and hilights cells blue (ColorIndex = 5) if they are over a...- ElkySS
- Thread
- Replies: 2
- Forum: Microsoft: Office
