| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I count the number of cells with blue shading in Excell?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I count the number of cells with blue shading in Excell?
|
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I count the number of cells with blue shading in Excell?
See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "drbrow592" wrote in message ... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I count the number of cells with blue shading in Excell?
You could try this alternate method which doesn't use VBA or any add-ins.
In 2003 you can specify the Format color to look for under EditFindOptionsFormatFormat. Select the color from the Patterns dialog and Find All. In the found dialog box the first cell will be highlighted. Hold SHIFT key and scroll down to bottom of dialog box and select last cell. The selected cells can then be counted by right-click on Status Bar and "Count". Gord Dibben MS Excel MVP On Mon, 22 Oct 2007 13:44:01 -0700, drbrow592 wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count cells containing text values in Excell | Excel Worksheet Functions | |||
| Count IF function for color/shading of cells | Excel Discussion (Misc queries) | |||
| How do I count cells with a specific cell shading? | Excel Worksheet Functions | |||
| Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
| Excell-How to add the number of cells containing text? = a sum | Excel Worksheet Functions | |||
Linear Mode
