Formula to read code in Column D, then apply color to columns a, b, c?

On a sheet with 575 lines, I need to enter a formula, probably in column E, which will look at the code in Column D, then format the color of columns A, B, C. The code could be any one of 7 codes, 1a, 1b, 2a, 2b, 3a, 3b, N/A. The goal is to have all lines that have 1a in column D be one color (pink), all lines with 1b in column D be one color (green), and so on.

I do not have enough experience with IF or LOOKUP to figure this one out on my own, and would appreciate being pushed in the right direction for any on-line reading materials relating to this type of formula.

Thank you.

Lor

I'll get a chance to try this tomorrow. Thank you for the quick response.

Lorann