Home |
Search |
Today's Posts |
#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. . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |