| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNT COLOURED CELL
In Excel Sheet there are many cells colored with "RED" and many are colored
with "YELLOW" is there any formula to count number of Cells which are "RED" and number of Cells which are "YELLOW".....hope some one understand.......thanks -- Message posted via http://www.officekb.com |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNT COLOURED CELL
hi
see these sites.... http://www.xldynamic.com/source/xld.ColourCounter.html http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm regards FSt1 "adeel via OfficeKB.com" wrote: In Excel Sheet there are many cells colored with "RED" and many are colored with "YELLOW" is there any formula to count number of Cells which are "RED" and number of Cells which are "YELLOW".....hope some one understand.......thanks -- Message posted via http://www.officekb.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count coloured cell in a particular range ? | Excel Worksheet Functions | |||
| XL2003: Count formatted cells (not coloured)... | Excel Worksheet Functions | |||
| Count coloured cells in range | Excel Worksheet Functions | |||
| Count coloured cells in a range | Excel Worksheet Functions | |||
| count coloured cells | Excel Worksheet Functions | |||
Linear Mode
