Count color backgrounds

Greetings, I got a question about a function. My skills in VBA isn’t that great, so sorry. But, what I want is a function that will check e.g. cell L5 till L2000, what the background color is. When it changes to green, it will count how many cells from L5 till L2000 is, and then place the count on a specific cell. Is that possible? Is it possible to place that on a loop or something? So it will automaticly call the function. Thank you very much.

By: Ariyen Shoj

Leave a Reply

Your email address will not be published. Required fields are marked *