| 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In Excel, how do I count cells with a particular format (e.g. colo
Look he
http://xldynamic.com/source/xld.ColourCounter.html -- Kind regards, Niek Otten Microsoft MVP - Excel "voyagerff" wrote in message ... |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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In Excel, how do I count cells with a particular format (e.g. colo
http://www.cpearson.com/excel/colors.aspx
-- David Biddulph "voyagerff" wrote in message ... 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In Excel, how do I count cells with a particular format (e.g. colo
To count colored red cells.................
Select the sheet's used range. EditFindFormatFormatPatterns Pick the red color and OK Find All In the "found" dialog hit SHIFT + End Right-click on the Statuys Bar and "count" Gord Dibben MS Excel MVP On Thu, 25 Sep 2008 09:37:01 -0700, voyagerff wrote: 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. |
| Reply |
| 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 | |||
Linear Mode
