| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excel, how do I count cells with a particular format (e.g. colo
I inherited a large spreadsheet with certain rows colored red. I want to be
able to count the red rows (or cells). Is there some function that can test for a cell's formats? Or is there some technique using macros? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count cells according to format | Excel Discussion (Misc queries) | |||
| Count of Cells Based on Format | Excel Discussion (Misc queries) | |||
| Count cells by format | Excel Worksheet Functions | |||
| Can one count cells having a certain format? i.e. using countif? | Excel Worksheet Functions | |||
| Count and Sum cells with certain format (e.g. color) | Excel Worksheet Functions | |||
Threaded Mode
