Drop down list with sub list

Just what I was looking for

Thank You very much

Using the example above is there a way to color code an adjacent cell based on the list results?

I am adding a third column for a comments field and would like to highlight the cells in the comment field with a color dependant on the catagory chosen in the first column.

I am assuming I can use conditional formatting, but don't know how to apply this using list results

Thank You

Once again, just what I was looking for

Thank You very much