I need a VBA function that count cells conditionally formatted by colour. I have three different colours; green, yellow and red, and I am using a formula to determine which cells to format. I have tried several functions found online, but every one of them return errors which I suspect is because I use non-standard colour codes, although I am not sure.
Please see attached spreadsheet.
Bookmarks