looking to compile.

[the big man]

Hi there!

I'm having some dificuty with my excel skills, in a nutshell I'm creating a inspection log grid an my cells are formated to change colors I.E:
1= green
2= yellow
3= orange
4= red

what im trying to do is to create a section at the bottom to count the amount of cells with the same value by colomb I.E:
columb 1 has 5 green, 7 yellow etc..
columb 2 has ...
columb 3 has ...

i've been poking around at this for ever now.

i apreciate the help!
Cheers!

 

[JackDanIce]

Have a read of: Count The Number of Cells With Specific Cell Color By Using VBA

 

[the big man]

Have a read of: Count The Number of Cells With Specific Cell Color By Using VBA

Brilliant! i will give that a shot.

thank you very much Jack.
cheers.

 

[JackDanIce]

You're welcome, hope it helps

 

[PaddyD]

If the cell colour is driven by the cell values, can't you just count the values in the columns using countif()s ?

 

[the big man]

it did, already finished.

million thanks again.