I would like to know if there is some way to automate symbology based on my attributes. I have a list of zipcodes and a column which contains ID-codes of waterstations delivering water in that area. If zipcodes only have one water station delivering water, the column is filled with one ID. But some zip codes have several water stations delivering there. The column cell is then filled with several ID's (see image). Is there a way to give a specific color to an ID? For instance: ID 32.06 gets a brown color, ID 32.09 gets a yellow color. If a zip codes have both stations, the polygons fills a mix of yellow and brown lines. If a zipcode has only one of the two, it fills the polygon with either brown or yellow (see image).
I can do this manually but there are over 400 possibilities which makes this a very time consuming activity.