Counting Formated Cells

[birdismyers]

Can anyone help me on this?

I am trying to count the number of cells in a row that are highlighted
with yellow.

 

[Chip Pearson]

You have to use a VBA function to do this. See the CountByColor procedure at
www.cpearson.com/excel/colors.htm



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[birdismyers]

I found the CountByColor tip, but don't know how to enter it into VBA.
Can someone have a look at the included worksheet where I've
highlighted various cells in Row 4, with an attempt to count the
highlighted cells and total them in Cell S4?

If you could put the VBA in the sheet for me as an example for me to
work off, I'd greatly appreciate it.

File Attached: http://www.excelforum.com/attachment.php?postid=325455 (countbycolor help.xls)