Hi,

Select the cell and go to FormatConditional Formatting.
Select "Cell Value", "equal to", "HD" (this last one should not be in
apostrophe"
Now go to format and select the desired in the Pattern tab
Click on OK and OK again

Regards,

Ashish


"YanYan" wrote:

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?