See http://www.xldynamic.com/source/xld.ColourCounter.html

--

HTH

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


"Stephanie D" <Stephanie wrote in message
...
Can anyone tell me a formula that will count the number of yellow cells in
a
range.
I used =countif(AV2:HM2,"interior.colorindex = 36"). I don't get a error
message. I get "2", when it shoudl be 3 -- no matter how many yellow cells
there are, I always get "2". What am I doing wrong? sd