Count a cell based on colour of the cell

[davygryan]

Is it possible to count cells based on the colour of the cell.

Thanks for your help

D

 

[VoG]

If they are manually coloured try this http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm

 

[davygryan]

If they are manually coloured try this http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm

Is is possible to do this without using VBA as I am not that familiar with it

Thaks for the response

 

[VoG]

No, it is only possible using VBA.

The link I posted explains exactly what to do.

 

[T. Valko]

Is is possible to do this without using VBA as I am not that familiar with it

Thaks for the response

Maybe you can construct a formula based on the logic of WHY the cells are a certain color.