Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to count cells that are highlighted by conditional formatting
How do I return a count of how many cells in a range are highlighted (via
conditional formatting) without using VBA in Excel 2007? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to count cells that are highlighted by conditional formatting
What conditions are used to set the CF in those cells? You need to
construct a formula which incorporates those conditions - this might be a simple SUMIF if the condition is simple (eg cell greater than 10), but may need to be more complex than this. Post back with further details if you need more help. Hope this helps. Pete On Feb 10, 3:11*pm, jngbutler35 wrote: How do I return a count of how many cells in a range are highlighted (via conditional formatting) without using VBA in Excel 2007? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNT HIGHLIGHTED CELLS IN A ROW ? | Excel Discussion (Misc queries) | |||
COUNT CELLS WITH CONDITIONAL FORMATTING | Excel Worksheet Functions | |||
Count cells that meetin conditional formatting criteria | Excel Worksheet Functions | |||
count highlighted cells | Excel Discussion (Misc queries) | |||
Count highlighted cells | Excel Worksheet Functions |