Count cell shading

K

Karthik

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....
 
T

T. Valko

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
 
K

Karthik

Thanks T.Valko....
--
Karthi


T. Valko said:
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
Click to expand...
 
Top