Is someone manually colouring the rows? Would be much easier to use conditional formatting and a code to indicate the failure level?
e.g. a scale of 1 to 7 and then use conditional formatting to format the whole row based on that value.
In the absence of that I think you'll be down to VBA to count the colours. I can have a go if you want? I'm not aware of any formula to detect colour.
__________________
Current: E90 335d (May 2007) | Black/Black | Prof Hifi | Prof Nav | 6FL | Fully Electric Seats | Xenons | Folding Mirrors | PDC
Previous: 325ci Conv. Black/Black with lots of ACS
Previous: z3 3.0 Silver with Black&Red Leather
|