|Subject:||Count If on colours in a cell?|
|Date:||Thu, 11 May 2006|
i have a spreadsheet that i use define what my collegues are doing e.g on
holiday,sick, BAU, or Projects amongst others and each one has a colour code.
at the end of the period i would like to count the number of cells that are
coloured red = sick, the number of cells that are blue =project etc etc.
Is there away i can do this the cells are just coloured and have no text or
numbers written in them.