detect cell color and count it
 

Hi,

I have a sheet ("January") in which some cells are colored with particular
color, i would like to know if exists a method how to detect these particular
cells and to count their number ? (if possible without using VBA).

thanks,
Maileen

See

http://www.xldynamic.com/source/xld.ColourCounter.html
Processing Coloured Cells

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Maileen" wrote in message
...
Hi,

I have a sheet ("January") in which some cells are colored with particular
color, i would like to know if exists a method how to detect these
particular
cells and to count their number ? (if possible without using VBA).

thanks,
Maileen

Maileen

If cells are colored due to Conditional Fornmtting, you could count using the
same crirerion(a) that CF uses.

If not CF-colored, Bob's VBA is the only way to go.


Gord Dibben Excel MVP

On Wed, 30 Mar 2005 22:05:02 -0800, "Maileen"
wrote:

Hi,

I have a sheet ("January") in which some cells are colored with particular
color, i would like to know if exists a method how to detect these particular
cells and to count their number ? (if possible without using VBA).

thanks,
Maileen