I have a validation list on my worksheet, the list includes different codes
such as HD, SL, OR and RES. Whenever HD is chosen, I want it to turn red,
whenever RES is chosen, I want it to turn purple. How do I do this?