Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Use the formula that the Conditional format is based on to calculate your
count. There is no built-in way of counting color within XL, and even using VB, counting conditional formats is tricky. -- Best Regards, Luke M "AOdoc" wrote in message ... I am trying to count the cells in a range that have a certain fill color in Excel 2003. Is there a way to use COUNTIF? If so, how do I write the criteria for the color I'm looking for? Or, is there another formula? Many thanks to whomever can answer this one! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting Colors of Cells set by Conditional Formatting | Excel Worksheet Functions | |||
Conditional formatting and counting. | Excel Discussion (Misc queries) | |||
counting cells based on conditional formatting | Excel Discussion (Misc queries) | |||
Counting Cells with Conditional Formatting | Excel Discussion (Misc queries) | |||
counting cells with conditional formatting applied | Excel Discussion (Misc queries) |