| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Cells with colors
There is no built in function in Excel to do that, but there is a macro you
can use. If you want it, you can do a search in the search for box with count color. "JimW" wrote: There might also be text in the cell but I want to count it based strictly on the color "Sean Timmons" wrote: Which version of Excel do you have? "JimW" wrote: Is there a formula that will count cells that contain different colors. Blank with no data just colored. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting Cells with colors
Or, you can buy "Colored Cells Assistant" only 29.95. I was hoping there was
another way. "Sean Timmons" wrote: There is no built in function in Excel to do that, but there is a macro you can use. If you want it, you can do a search in the search for box with count color. "JimW" wrote: There might also be text in the cell but I want to count it based strictly on the color "Sean Timmons" wrote: Which version of Excel do you have? "JimW" wrote: Is there a formula that will count cells that contain different colors. Blank with no data just colored. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Colors on a worksheet | Excel Worksheet Functions | |||
| Sum Cells with colors | Excel Worksheet Functions | |||
| Counting colors | Excel Discussion (Misc queries) | |||
| 2 cells 2 colors | Excel Discussion (Misc queries) | |||
| Sum cells in different colors | Excel Discussion (Misc queries) | |||
Hybrid Mode
