Counting cells of a specific color
Thank you, Gord, this is an excellent way to get a quick manual count.
However, how do you incorporate this into a cell cell formula in Excel 2007
so that you can maintain a continual dynamic count in a cell on the
worksheet?
Thanks,
Richard
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
For counting only...................
Select the range of cells then EditFindFormatChoose from cellSelect a
cell from the custom colors legendOK
In "Found" dialog hit CTRL + a.
Right-click on Status Bar and "Count"
Gord Dibben MS Excel MVP
On Tue, 27 Jan 2009 19:51:16 -0700, "Blue Max"
wrote:
Can anyone recommend a good formula for counting the cells of a common
color
in a range?
We have a color-coded visual schedule, but need to count the cells of a
common color to determine if we have allocated enough resources to a
particular task. Please note that the assigned colors are related to a
certain task (in a legend) and are often custom colors not chosen directly
from the standard palette.
|