| Home |
| Search |
| Today's Posts |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count colored cells?
Sorry about the response time...I did not see your message. The
ColorCount is a Function. Open the Visual Basic Editor (Tools-Macro-Visual Basic Editor --or-- ALT-F11). Choose Insert-Module (not class module). Copy and paste the code in the last post and then you can use the function in your spreadsheet using the following syntax: =CountColor(ColorName,Range) =CountColor("Dark Red",A1:B5) will count the Dark Red backgrounds in the range A1 to B5. One Caution: The line: If mycell.Interior.ColorIndex = myColorIndex Then CountColor = CountColor + 1 is all one line. It might not paste that way. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| how 2 Count number of cells that have specific condition format? | Excel Worksheet Functions | |||
| Count cells in one range based on parameters in another range | Excel Worksheet Functions | |||
| How do I count shaded cells | Excel Worksheet Functions | |||
| Count or sum colored cells | Excel Worksheet Functions | |||
Threaded Mode
