| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count cell shading
Hi,
Is there a way to count number of cells that are shaded in Green and Red. I am pretty weak in VBA codes and not familiar using macros. Someone please let me know a solution for this. Thanks for your help in advance.... -- Karthi |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count cell shading
Can you write a formula to count the cells based on *why* they are the color
they are? There's reason the cells are either green or red. If you can't do that then VBA is needed and it's kind of complicated and it won't exactly work the way you think it'll work. See this: http://www.cpearson.com/Excel/colors.aspx Pay special attention to this section: Color Change And Calculation -- Biff Microsoft Excel MVP "Karthik" wrote in message ... Hi, Is there a way to count number of cells that are shaded in Green and Red. I am pretty weak in VBA codes and not familiar using macros. Someone please let me know a solution for this. Thanks for your help in advance.... -- Karthi |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count cell shading
Thanks T.Valko....
-- Karthi "T. Valko" wrote: Can you write a formula to count the cells based on *why* they are the color they are? There's reason the cells are either green or red. If you can't do that then VBA is needed and it's kind of complicated and it won't exactly work the way you think it'll work. See this: http://www.cpearson.com/Excel/colors.aspx Pay special attention to this section: Color Change And Calculation -- Biff Microsoft Excel MVP "Karthik" wrote in message ... Hi, Is there a way to count number of cells that are shaded in Green and Red. I am pretty weak in VBA codes and not familiar using macros. Someone please let me know a solution for this. Thanks for your help in advance.... -- Karthi |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count if a cell has color shading | Excel Discussion (Misc queries) | |||
| How do I count the number of cells with blue shading 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 | |||
Linear Mode
