Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting cells by font color
I just upgraded to excel 2007 but I still can't figure out what I need to do!
I need to come up with a way to count non-blank cells by font color. I have a list of 10 names and I currently have a counta function set to count only the non-blank cells. Now my boss wants to see that number turned into a calculation that counts the number of active names (in this case black font), and ignore the inactive names (gray font). How would I write that to produce anything other than the error message I've become so used to? -- Have a great day! Sincerely, Cassie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I can't change font color in certian cells. | Excel Discussion (Misc queries) | |||
Counting cells with colored font | Excel Worksheet Functions | |||
Cells won't change font color or show hi-lighted cells in document | Excel Discussion (Misc queries) | |||
keeping font color when linking cells | Excel Worksheet Functions | |||
Counting all cells with red font in Excel | Excel Worksheet Functions |