Setting dynamic links to a speciffic colour
Just to add a little more detail,
you can see from the image that it shows the property number, the address and underneath that it says 'No Clean'. It is these property numbers that need to be colour coded. It will then save the guys clicking on each property to see what need doing. Some of these streets can have upto 30 properties on them, so colour coding seems to be the best way to go about things.
sorry to ramble on, hopefully you can see where I am coming from.