See www.cpearson.com/excel/colors.htm for a sample VBA function
to do this.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"darkbearpooh1"

wrote in message
news:darkbearpooh1.224e4y_1138074302.0157@excelfor um-nospam.com...

hi can anyone help me get a cell to count the number of other
cells just
colored a specific color?

looked at other post came up with something like
=COUNTBYCOLOR(A1:A10,3,FALSE)
but can not get it to work


--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile:
http://www.excelforum.com/member.php...o&userid=30640
View this thread:
http://www.excelforum.com/showthread...hreadid=504284