I am creating a worksheet for use in our sales department. What I want to do
is create a formula that will highlight a row of cells when specific data is
entered into one cell within that row.

Example: If "D" is entered into the specific cell, it will highlight the
row of cells in "yellow". If "X" is entered into the specific cell, it will
highlight the row of cells in "pink".

Is there a formula that will allow me to do this? Any assistance would be
greatly appreciated.

Thanks