Thread
:
How do you count cells with background color yellow?
View Single Post
#
7
Stephanie D
Posts: n/a
How do you count cells with background color yellow?
Thanks Bob. This one is clearer. sd
"Bob Phillips" wrote:
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
Reply With Quote