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


"birdismyers" wrote in message
...
Can anyone help me on this?

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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/