Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Count highlighted cells
I need a formula to count how many manually highlighted/shaded/colored cells
are in a specific column in a worksheet. I have a list of items (collectibles) that I highlight as I find. I want to keep track of the total number of items I have without having to physically count all the items. |
#2
|
|||
|
|||
I don't think you can do this with a formula (but, I'm often wrong). Try
Chip Pearson's site for information on functions to count colours: http://www.cpearson.com/excel/colors.htm HTH Steve "Robbie in Houston" <Robbie in wrote in message ... I need a formula to count how many manually highlighted/shaded/colored cells are in a specific column in a worksheet. I have a list of items (collectibles) that I highlight as I find. I want to keep track of the total number of items I have without having to physically count all the items. |
#3
|
|||
|
|||
See Chip Pearson's site for code.
http://www.cpearson.com/excel/colors.htm Cannot be done with Excel native Functions. Gord Dibben Excel MVP On Tue, 15 Feb 2005 15:35:02 -0800, "Robbie in Houston" <Robbie in wrote: I need a formula to count how many manually highlighted/shaded/colored cells are in a specific column in a worksheet. I have a list of items (collectibles) that I highlight as I find. I want to keep track of the total number of items I have without having to physically count all the items. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I count how many grey-filled cells are in a row ? | Excel Worksheet Functions | |||
COUNT ONLY CELLS THAT AREN'T BLANK | Excel Worksheet Functions | |||
Count non-colored cells | Excel Discussion (Misc queries) | |||
Count number of shaded cells | Excel Discussion (Misc queries) | |||
Count cells with data | New Users to Excel |