Count color excel

[robato]

Hi,
I'm using a macro to count the cells with a specific background using this function:
https://support.microsoft.com/en-us/...r-by-using-vba

The script works perfectly but sometimes it see grey color as green but not all the time, does anyone know this happens?
I've shared the excelfile if you want to have a look, it's makroactivited but I can promise you it's nothing harmful.

https://www.dropbox.com/s/g80oskxw91...olor.xlsm?dl=0

I use Excel 2013.

[Leith Ross]

Hello robato,

This version of your macro worked for me...

Please Login or Register  to view this content.

[robato]

Thanks for your reply, that didn't do the trick! I've attached an image with the colors that are causing the problem. My biggest issue is that it's a bit unrealiabe, in some cases it also counts the lighter grey as green but in most cases it doesn't.
Tricky color.jpg