| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I count cells of a specific colour (pattern)?
We have a 'calendar' worksheet which users complete to record holidays,
special leave etc. Cells are given different colours (using format cells, patterns) to represent different types of leave. Is there any way to count the number of each colour of cell - for examle the number of red patterned cells in each row? Product is Excel 2000. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count a value if another field = a specific value? Excel | Excel Worksheet Functions | |||
| how to format only a specific character or number in each cell withina range of cells | Excel Worksheet Functions | |||
| Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
| Can I count how many grey-filled cells are in a row ? | Excel Worksheet Functions | |||
| Locate and delete specific cells | Excel Discussion (Misc queries) | |||
Threaded Mode
