Count?

[bradg12]

Hey,

I'm using a conditional formatting to highlight cells.

Is there any command to count how many cells are highlighted.


My example is I've created a roster to highlight peoples shifts across the sheet.

At the bottom, I'd like to include a table to count the total cell highlighted vertically.

 

[Dr Dee]

I'm no expert, but if you are using formulae to do the conditional formatting why can't you use the same to do the cell count?

 

[Ruddles]

That's the way to do it.

 

[abmati]

Please refer the following link:

http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm

Regards

Mati

 

[Ruddles]

Mati, have you tried using those techniques to count cells by colour when the colours have been applied by conditional formatting?