| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a way to count the number of different colored cells?
I have uniqure colored rows in my excell spreadsheet. Is there a formula to
count the total number of green rows, red rows, blue rows, etc? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there a way to count the number of different colored cells?
You will have to use code; Chip Pearson show how...
http://www.cpearson.com/excel/colors.htm -- Jim Cone San Francisco, USA http://www.officeletter.com/blink/specialsort.html "MCM" wrote in message I have uniqure colored rows in my excell spreadsheet. Is there a formula to count the total number of green rows, red rows, blue rows, etc? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count them number of cells between values -2 and 2 including 0 | Excel Discussion (Misc queries) | |||
| Count number of cells with date <today's date | New Users to Excel | |||
| count the number of cells with a date <= today's date | New Users to Excel | |||
| Count the number of Cells in one ROW with conditions | Excel Worksheet Functions | |||
| how do I 'count' the number of cells with a text in red or black? | Excel Worksheet Functions | |||
Linear Mode
