| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting cells with a specific background colour | Excel Discussion (Misc queries) | |||
| HOW TO FORMATE CELLS TO COUNT CELLS WITH A FILL COLOR? | New Users to Excel | |||
| highlight cells equals sum, not count | Excel Discussion (Misc queries) | |||
| Can I count cells with specific format (e.g., yellow field?) | Excel Worksheet Functions | |||
| how 2 Count number of cells that have specific condition format? | Excel Worksheet Functions | |||
Hybrid Mode
