Home |
Search |
Today's Posts |
#1
|
|||
|
|||
COUNTIF using formatting?
Here is a basic example of what I'm trying to do:
I have a list of football teams. Each week, I format the football teams that won with red font. Is there a way to find a count of those teams formatting in red and display that number in my worksheet? I know an alternate way around this would be to have a win/loss column and do a COUNTIF based on the values there. But I'm wondering if there's a way to do it based on the formatting instead of the values. |
#2
|
|||
|
|||
Nicolle K. wrote:
Here is a basic example of what I'm trying to do: I have a list of football teams. Each week, I format the football teams that won with red font. Is there a way to find a count of those teams formatting in red and display that number in my worksheet? I know an alternate way around this would be to have a win/loss column and do a COUNTIF based on the values there. But I'm wondering if there's a way to do it based on the formatting instead of the values. No AFAIK - you need to flag the rows that correspond to the winning teams. |
#3
|
|||
|
|||
Yes, but it requires VBA. See:
http://www.xldynamic.com/source/xld.ColourCounter.html HTH Jason Atlanta, GA -----Original Message----- Here is a basic example of what I'm trying to do: I have a list of football teams. Each week, I format the football teams that won with red font. Is there a way to find a count of those teams formatting in red and display that number in my worksheet? I know an alternate way around this would be to have a win/loss column and do a COUNTIF based on the values there. But I'm wondering if there's a way to do it based on the formatting instead of the values. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Losing conditional formatting when saving | Excel Discussion (Misc queries) | |||
Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Pivot Table Drill Down Number Formatting | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |