So if I have a drop list in column A and want to highlight certain cells on the same row depending on what was selected on the drop list, how can I do this. Do I have to code it in VBA or is there another solution?