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

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

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